Home » SQL & PL/SQL » SQL & PL/SQL » functions
functions [message #238292] Thu, 17 May 2007 06:14 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi friends,

Is possible use ref cursor in functions?
Expecting your replies..

Arun..
Re: functions [message #238299 is a reply to message #238292] Thu, 17 May 2007 06:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Yes.

If you could explain exactly what you mean, I can give a better answer.
Re: functions [message #238302 is a reply to message #238292] Thu, 17 May 2007 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible.

Regards
Michel
Re: functions [message #238308 is a reply to message #238302] Thu, 17 May 2007 06:46 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

HI michel,

Can u give some coding ..pls

Arun..
Re: functions [message #238310 is a reply to message #238308] Thu, 17 May 2007 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are some in Oracle documentation.
You know the link. Very Happy

Regards
Michel
Re: functions [message #238322 is a reply to message #238308] Thu, 17 May 2007 07:16 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you tell us what you're looking for then possibly.
Do you want functions that take Ref Cursors as IN parameters, functions that use their own Ref Cursors internally, functions that return Ref Cursors, or what?
Re: functions [message #238329 is a reply to message #238322] Thu, 17 May 2007 07:25 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
http://www.orafaq.com/forum/fa/448/0/

Read all about it in the documentation. Or, hit the search button here.

MHE
Previous Topic: New Issue in ORDER BY 10g
Next Topic: SQL query do not show all records ...
Goto Forum:
  


Current Time: Tue Dec 06 04:19:36 CST 2016

Total time taken to generate the page: 0.11916 seconds