Re: [Squirrel-sql-users] Comment placement in CREATE PACKAGE

[Drav S. <hol...@re...>]

David Pinho wrote:
> I'm seeing a strange behavior (well strange for me anyway). When
> creating a package in an Oracle DB:
> 
> If i execute this in SQuirreL:
> 
> CREATE OR REPLACE PACKAGE foo AS
> 
> /* comment */
> c1 CONSTANT INTEGER := 1;
> 
> FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER;
> 
> END foo;
> /
> 
> It will execute fine and create the package. But if i change the
> position of the comment line:
> 
> CREATE OR REPLACE PACKAGE foo AS
> 
> c1 CONSTANT INTEGER := 1;
> /* comment */
> 
> FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER;
> 
> END foo;
> /
> 
> it will fail with the error:
> Query 1 of 4, Rows read: 0, Elapsed time (seconds) - Total: 0.02, SQL
> query: 0.02, Reading results: 0
> Error: Invalid SQL type: sqlKind = 0
> SQLState:  99999
> ErrorCode: 17439
> Position: 0
> Error occured in:
> /* comment *
> 
> 
> If i run it in SQLPlus it will run just fine. Any ideias what this
> might be or how i can get around it?
> 
> I'm using Oracle 10.2.0.4.0 and SQuirreL 3.4.0 (Oracle Thin Driver).

I'm running Oracle 10.2.0.4.0 (64-bit), Squirrel 3.4.0 and the
oracle ojdbc 6.0 thin client and both the above run without giving
any errors... 

:/

D.