Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to execute procedure returning refcursor from sqlplus

Re: How to execute procedure returning refcursor from sqlplus

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 18 Dec 2006 11:12:42 -0500
Message-ID: <9177895d0612180812v33991730w78a6a66516b7e2f7@mail.gmail.com>


var myref refcursor
exec my_proc(:myref,param1,param2,...);
print :myref

Raj

On 12/18/06, Harvinder Singh <Harvinder.Singh_at_metratech.com> 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?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 18 2006 - 10:12:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US