Re: Executing a Oracle Stored Procedure
From: <seci_at_ludens.elte.hu>
Date: 1996/11/06
Message-ID: <1996Nov6.120905.33505_at_ludens>#1/1
>>
>> 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
>> /
>>
Date: 1996/11/06
Message-ID: <1996Nov6.120905.33505_at_ludens>#1/1
hi,
In article <327666E2.4F0B_at_charlie.cns.iit.edu>, AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu> writes:
> 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
>> /
>>
try
variable test number execute johns_proc(:test) print test
in SQLDBA
>> ***************************
>> 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) HTH peterReceived on Wed Nov 06 1996 - 00:00:00 CET