should be variable r refcursor DECLARE P_INTERVAL NUMBER; BEGIN P_INTERVAL := 885653507; Proce ( P_INTERVAL, :r ); COMMIT; END; / print r Key: the pl/sql block is executed by the server, the server sets the :r output bind variables, which maps to the r variable inside sqlplus - then sqlplus prints it. On 12/18/06, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote:
I tried these options but getting error: DECLARE P_INTERVAL NUMBER; v_cursor refcursor; BEGIN P_INTERVAL := 885653507; Proce ( P_INTERVAL, :v_cursor ); print :v_cursor; COMMIT; END; / SP2-0552: Bind variable "V_CURSOR" not declared -----Original Message----- From: rjamya [mailto:rjamya@xxxxxxxxx] Sent: Monday, December 18, 2006 11:13 AM To: Harvinder Singh Cc: oracle-l Subject: Re: How to execute procedure returning refcursor from sqlplus var myref refcursor exec my_proc(:myref,param1,param2,...); print :myref Raj On 12/18/06, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote: > 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? -- //www.freelists.org/webpage/oracle-l
-- Alberto Dell'Era "Per aspera ad astra" -- //www.freelists.org/webpage/oracle-l