Home » SQL & PL/SQL » SQL & PL/SQL » how stored Functions Return More than one values?
how stored Functions Return More than one values? [message #217180] Thu, 01 February 2007 00:45 Go to next message
victoryhendry
Messages: 95
Registered: January 2007
Location: Bangalore
Member

how stored Functions Return More than one values?
Re: how stored Functions Return More than one values? [message #217181 is a reply to message #217180] Thu, 01 February 2007 00:47 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try to use OUT / INOUT parameters depending on your requirement.

By
Vamsi
Re: how stored Functions Return More than one values? [message #217183 is a reply to message #217181] Thu, 01 February 2007 00:52 Go to previous messageGo to next message
victoryhendry
Messages: 95
Registered: January 2007
Location: Bangalore
Member

Thanks.
Its possible to use out parameter in Functions? in oracle 8i....
Re: how stored Functions Return More than one values? [message #217189 is a reply to message #217183] Thu, 01 February 2007 01:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Simply try it.
Suppose we answer it is not possible, would you not quickly try if we were right?
Suppose we answer it is possible, would you blindly throw your function with out-parameters to production?
Re: how stored Functions Return More than one values? [message #217191 is a reply to message #217183] Thu, 01 February 2007 01:48 Go to previous message
nmuthusa
Messages: 2
Registered: January 2007
Location: India
Junior Member
Hi,

we can use OUT parameters in oracle 8i.

- Nmuthusa
Previous Topic: Simple FULL OUTER JOIN but yet to be doing the JOIN desired
Next Topic: how insert the data in procedure in run time?
Goto Forum:
  


Current Time: Sun Dec 11 00:19:31 CST 2016

Total time taken to generate the page: 0.07428 seconds