Can somebody tell me how to execute an stored Procedure in SQL Plus?
Can you give me an example?
Thanks
Printable View
Can somebody tell me how to execute an stored Procedure in SQL Plus?
Can you give me an example?
Thanks
Try:
exec myproc
let this be your first proc in your sql*plus...
Check out examples on the document lib..Code:
appdev@NICK817.TARRY.LOCAL> declare
2 l_tst varchar2(30);
3 begin
4 null;
5 end;
6 /
PL/SQL procedure successfully completed.
http://download-west.oracle.com/docs...h8.htm#1013594
Thanks!