|
From: Robert M. <rob...@gm...> - 2012-10-12 11:11:25
|
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 <dav...@gm...> 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
