Re: Trouble executing storedprocs in SQuirreL

I've never had any luck running anonymous PL/SQL blocks outside  
Oracle's tools (though I would love info on getting it to work, if it  
can be done).

For your example, you could try this instead:

        select DELETE_BY_LOAN('123435') from dual;

Rob

On Jun 18, 2007, at 1:22 PM, Karr, David wrote:

> I'm having trouble executing a storedproc in SQuirreL (2.5).  If the
> name of the storedproc is "DELETE_BY_LOAN" and it takes a single  
> string
> parameter, what exactly should I type in the SQL window?
>
> I would guess it would be:
>
>       begin DELETE_BY_LOAN('123435'); end;
>
> And then I press Ctrl-enter.  When I do this, it says:
>
> ------------
> Error: java.sql.SQLException: ORA-06550: line 1, column 44:
> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> the following:
>
>    := . ( % ;
> , SQL State: 65000, Error Code: 6550
> Error occured in:
> begin DELETE_BY_LOAN('123435')
> ------------
>
> I tried the similar test in SQLDeveloper, and it works fine.
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/