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: 26766
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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: Thu Feb 13 13:07:28 CST 2025