Home » SQL & PL/SQL » SQL & PL/SQL » function is said to be return only one value but ....? (oracle 9i ,Win XP)
icon14.gif  function is said to be return only one value but ....? [message #292801] Wed, 09 January 2008 22:00 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

Function is said to be return only one value
but when we using out and in out parameters in a function we will get more than one
value (but only one value is returned in the variable is that why its said function
return only one value
ie: f=funcname(jk in number,gh out number,ga in out number); )


Please clarify my doubt


Thanks in Advance

[Updated on: Wed, 09 January 2008 22:02]

Report message to a moderator

Re: function is said to be return only one value but ....? [message #292802 is a reply to message #292801] Wed, 09 January 2008 22:13 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
You are correct.
Re: function is said to be return only one value but ....? [message #292844 is a reply to message #292801] Thu, 10 January 2008 00:53 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More precisely, a function return (in its return statement) one element of the returned type.
This returned type may be complex and contains several values, for instance in case of record or array.

Regards
Michel
Previous Topic: SQL command not properly ended
Next Topic: Date manipulation
Goto Forum:
  


Current Time: Fri Dec 09 11:38:11 CST 2016

Total time taken to generate the page: 0.12802 seconds