Home » SQL & PL/SQL » SQL & PL/SQL » Function and ref cursor questions
Function and ref cursor questions [message #358330] Mon, 10 November 2008 14:12 Go to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Can anyone tell me the proper definition of Ref Cursor?

[MERGED by LF]

[Updated on: Mon, 10 November 2008 14:44] by Moderator

Report message to a moderator

Function [message #358331 is a reply to message #358330] Mon, 10 November 2008 14:13 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Can we use the OUT and INOUT mode in function?
Re: Function [message #358336 is a reply to message #358331] Mon, 10 November 2008 14:45 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are these Forms questions, or general PL/SQL ones?
Re: Function [message #358393 is a reply to message #358336] Tue, 11 November 2008 01:46 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Sorry, its PL/SQl question
Re: Function and ref cursor questions [message #358399 is a reply to message #358330] Tue, 11 November 2008 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Ctl-F -> cursor

Regards
Michel
Re: Function [message #358405 is a reply to message #358331] Tue, 11 November 2008 02:31 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use OUT and IN OUT parameters for functions, but it's bad practice.
Functions should take IN parameters and return a single value (possibly a collection or record).
Everything else should by implemented as a procedure.
Re: Function [message #358488 is a reply to message #358405] Tue, 11 November 2008 09:47 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
@JRowBottom

Oracle XE Apex object browser does not support in, out, inout in function only return Shocked , wheres on creation of procedure in,out,inout gets supported.
yours
dr.s.raghunathan
Re: Function [message #358500 is a reply to message #358488] Tue, 11 November 2008 11:06 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
No. I didn;t get the difinition of ref cursor from that site.....Will u just tell me definition of ref cursor and where we can use if?
Re: Function [message #358515 is a reply to message #358500] Tue, 11 November 2008 12:26 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you follow what I posted?

Regards
Michel
Previous Topic: Split Function for Input Blob
Next Topic: SAP4.7 installation SQL ERROR
Goto Forum:
  


Current Time: Sat Dec 10 07:03:12 CST 2016

Total time taken to generate the page: 0.04411 seconds