Executing a Oracle Stored Procedure

From: John Bush <jbush_at_netbox.com>
Date: 1996/10/29
Message-ID: <3276A054.49A7_at_netbox.com>#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
/

---

It would also be nice to display the value of TEST to the screen!

thanks in advance

-John Received on Tue Oct 29 1996 - 00:00:00 CET