Re: Executing a Oracle Stored Procedure

John Bush <jbush_at_netbox.com> wrote in article <3276A054.49A7_at_netbox.com>...
> 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

I think the DECLARE section should come first. Try this:

DECLARE
   TEST NUMBER;
BEGIN
   johns_proc(TEST);
   dbms_output.put_line(to_char(TEST));
END; Let me know if this helps or not.
Shawn Received on Wed Oct 30 1996 - 00:00:00 CET