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: 451
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: 26766
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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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: 451
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: Tue Dec 10 01:57:41 CST 2024