Re: Executing a Oracle Stored Procedure

John Bush <jbush_at_netbox.com> wrote:

Hi, try the following in sqlplus

SQL>variable test number
SQL>execute johns_proc(:test);
SQL>print test

test is now a sqlplus variable that is bound to the out parameter of johns_proc

-n

>I have created an oracle stored procedure,
>
>I would like to execute the procedure from sqlplus
>
>Unfortunately the docs dont give a descent example of how to to this
>with an out parm. Here is what I have, but it doesnt seem to work:
>
>***************************
>BEGIN
>
>DECLARE TEST NUMBER;
>
>EXECUTE johns_proc(TEST);
>
>END
>/
>
>***************************
>It would also be nice to display the value of TEST to the screen!
>
>thanks in advance
>
>-John
Received on Wed Oct 30 1996 - 00:00:00 CET