Home » SQL & PL/SQL » SQL & PL/SQL » procedure with refcursor (Oracle 9i)
procedure with refcursor [message #344893] Mon, 01 September 2008 11:49 Go to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi,

Is this possible to create a procedure which uses a ref cursor as an argument without using any packages. Please explain me how....?

Regards,
Pointers.
Re: procedure with refcursor [message #344895 is a reply to message #344893] Mon, 01 September 2008 11:59 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


You would do it the same way as you would create any procedure without a package.

The nummber or type of arguments is not relevant.
Re: procedure with refcursor [message #344896 is a reply to message #344893] Mon, 01 September 2008 12:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SYS_REFCURSOR.

Regards
Michel
Re: procedure with refcursor [message #344898 is a reply to message #344893] Mon, 01 September 2008 12:21 Go to previous message
pointers
Messages: 410
Registered: May 2008
Senior Member
Thanks Michael and anacedent....
Previous Topic: Query Vs Procedure on materialized view
Next Topic: case insensitive in data
Goto Forum:
  


Current Time: Fri Dec 09 05:36:06 CST 2016

Total time taken to generate the page: 0.13524 seconds