That would be a bug in the Oracle plugin's query tokenizer.   Can you put in a bug ticket for that here:

http://sourceforge.net/tracker/?group_id=28383&atid=393414

Rob

On Fri, Oct 12, 2012 at 4:42 AM, David Pinho <david.pinho@gmail.com> wrote:
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

------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users