Home » SQL & PL/SQL » SQL & PL/SQL » Can we pass OUT parameter in a function ?
Can we pass OUT parameter in a function ? [message #344757] Mon, 01 September 2008 03:43 Go to next message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
Can we pass OUT parameter in a function ?
If yes, what is the necessity of having return statement must in the function ?
Re: Can we pass OUT parameter in a function ? [message #344758 is a reply to message #344757] Mon, 01 September 2008 03:47 Go to previous messageGo to next message
BlackSwan
Messages: 25040
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


>Can we pass OUT parameter in a function ?
What happened when YOU tried it?
Re: Can we pass OUT parameter in a function ? [message #344764 is a reply to message #344757] Mon, 01 September 2008 04:00 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It is neccessary to have a RETURN statement in a function, because functions are defined as pieces of code that include a RETURN statment at the end of their execution.
It's tha simple.
Re: Can we pass OUT parameter in a function ? [message #344765 is a reply to message #344757] Mon, 01 September 2008 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes
2/ Because it is the definition of a function

Regards
Michel
Re: Can we pass OUT parameter in a function ? [message #344774 is a reply to message #344765] Mon, 01 September 2008 04:13 Go to previous message
ajayrajesh
Messages: 8
Registered: August 2008
Junior Member
thanks a lot for your prompt replies .. Smile
Previous Topic: Materialized view
Next Topic: Standards for Stored Procedures
Goto Forum:
  


Current Time: Mon Dec 05 23:59:05 CST 2016

Total time taken to generate the page: 0.08766 seconds