How to execute procedure returning refcursor from sqlplus
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Dec 2006 10:49:28 -0500
Hi,
We have a procedure that returns the sys_refcursor as an ouput and that
is select statement with 2 columns, now I have to execute that procedure
from sqlplus/toad and display the results, How can I declare a local
varaiables and execute the procedure and return thre result using
dbms_output?
Thanks
--Harvinder
Other related posts:
