|
From: Nathan A. <na...@gl...> - 2005-01-04 20:22:50
|
That worked. Thanks for the tip. Nathan Maury Hammel wrote: > Nathan: > >> I am trying to execute a Oracle procedure with SQuirreL 1.1final1. >> The following is an example: >> >> begin >> gr_report_tools.refresh_lovs(63); >> end; >> >> when I run that I get: >> >> Error: java.sql.SQLException: ORA-06550: line 2, column 39: >> PLS-00103: Encountered the symbol "end-of-file" when expecting one of >> the following: >> >> := . ( % ; >> >> What am I doing wrong? > > > You aren't doing anything wrong. SQuirreL doesn't know about Oracle > begin/end blocks, so it is trimming off the statement at the first > ';'. What it is sending to Oracle is 'begin > gr_report_tools.refresh_lovs(63)'. So, Oracle chokes on it. > > You can get around this by going to the Session properties and > temporarily changing the 'Statement Separator' in the SQL tab. I > usually use ` (back-quote), as it is something I don't usually find in > my begin/end blocks. > > > Maury... > > > > ------------------------------------------------------- > The SF.Net email is sponsored by: Beat the post-holiday blues > Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. > It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
