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

[David P. <dav...@gm...>]

Hi all,

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).


Tks,

David




-- 
http://davidpinho.net