Thread: [Squirrel-sql-users] Oracle Procedure
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Nathan A. <na...@gl...> - 2005-01-04 18:45:59
|
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? Nathan |
From: Maury H. <ml1...@sh...> - 2005-01-04 19:12:13
|
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... |
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 > |