Re: Executing a Oracle Stored Procedure
Date: 1996/10/31
Message-ID: <55aba6$i95_at_freenet-news.carleton.ca>#1/1
John Bush (jbush_at_netbox.com) writes:
> 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
You have executed a PL/SQL block ! It should be like this:
DECLARE
TEST NUMBER;
BEGIN
johns_proc(TEST); -- no EXECUTE
END;
Hope this help.
Manh-Hoa Le
Received on Thu Oct 31 1996 - 00:00:00 CET