Home » Other » Training & Certification » how to use a function as OUT variable inside a procedure
how to use a function as OUT variable inside a procedure [message #298625] Wed, 06 February 2008 19:32 Go to next message
ryuva4u
Messages: 2
Registered: February 2008
Junior Member
how to use a function as OUT variable inside a procedure Razz
Re: how to use a function as OUT variable inside a procedure [message #298627 is a reply to message #298625] Wed, 06 February 2008 19:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Is there any problem in doing that?
What did you write? Did you get any error?

By
Vamsi
Re: how to use a function as OUT variable inside a procedure [message #298650 is a reply to message #298625] Thu, 07 February 2008 00:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't use a function as OUT parameter.
This is meaningless.
Think about it. An OUT parameter is something that RECEIVES a value. A function is something that GIVES a value.

Regards
Michel
Re: how to use a function as OUT variable inside a procedure [message #298667 is a reply to message #298625] Thu, 07 February 2008 01:21 Go to previous messageGo to next message
raj1222
Messages: 5
Registered: February 2008
Location: hyd
Junior Member
hi,

The purpose of function is to take one or more arguments and return a single value.
if it returns more value the performance is decreased.
Re: how to use a function as OUT variable inside a procedure [message #298780 is a reply to message #298667] Thu, 07 February 2008 11:41 Go to previous message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between your comment and your original question?

Regards
Michel
Previous Topic: Vertual instance
Next Topic: oracle reports 60 tutorial
Goto Forum:
  


Current Time: Tue Apr 23 18:43:08 CDT 2024