How to execute Oracle stored procedures within Squirrel SQL ?

[Database Administrator]

Hi all

How to execute Oracle stored procedures from within Squirrel SQL.

I know "exec " works in SQL Plus.

Thanks
Steve

[Database Administrator]

"stonecoldsteve" wrote in message
news:1135709390.008154.264630@g43g2000cwa.googlegr oups.com...
> Hi all
>
> How to execute Oracle stored procedures from within Squirrel SQL.
>
> I know "exec " works in SQL Plus.
>
> Thanks
> Steve
>

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

[jaaguilarb]

Hi all.

In SquirrelSQL I can execute an Stored Procedure in this way:

call SP_NAME (PARAM1, PARAM2, ...)