Re: [Squirrel-sql-users] Oracle Procedure

[Maury H. <ml1...@sh...>]

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