OraFAQ Forum: Training & Certification » how to use a function as OUT variable inside a procedure

Home » Other » Training & Certification » how to use a function as OUT variable inside a procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use a function as OUT variable inside a procedure [message #298625]

Wed, 06 February 2008 19:32

ryuva4u
Messages: 2
Registered: February 2008

Junior Member

how to use a function as OUT variable inside a procedure Razz

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is the relation between your comment and your original question?

Regards
Michel

Report message to a moderator

Previous Topic:	Vertual instance
Next Topic:	oracle reports 60 tutorial

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 07:14:54 CST 2024