|
From: Rob C. <rw...@co...> - 2007-06-18 19:02:06
|
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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
