How to execute Oracle stored procedures within Squirrel SQL ?

[stonecoldsteve]

Hi all

How to execute Oracle stored procedures from within Squirrel SQL.

I know "exec <sp_name>" works in SQL Plus.

Thanks
Steve

[Mark C. Stock]

"stonecoldsteve" <opens...@gmail.com> wrote in message
news:1135709390.0...@g43g2000cwa.googlegroups.com...

don't know what Squirrel SQL is, but...

'exec' is a SQL*Plus command which is a shortcut for an anonymous
procedure -- that's why error messages (unhandled exceptions) look like
this:

SQL> exec some_procedure
BEGIN some_procedure; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SOME_PROCEDURE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

the actual syntax to execute a stored procedure from any environment that
can pass SQL to the database is usually to wrap the stored procedure call in
an anonymous block, aka:

BEGIN some_procedure; END;

++ mcs