Re: Executing a Oracle Stored Procedure

John Bush wrote:
>
> 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

before executing the procedure, do
SQL > set serveroutput on
and execute the proc.

AMAR

-- 
    AMARENDRA B NETTEM
    ORACLE CONSULTANT
    WHITTMAN-HART CORPORATION, CHICAGO
    (http://www.iit.edu/~nettama)