How to execute procedure returning refcursor from sqlplus

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
 

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 18 2006 - 09:49:28 CST