Home » Other » Training & Certification » OUT & IN OUT
OUT & IN OUT [message #287553] Wed, 12 December 2007 11:29 Go to next message
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
Senior Member
Can we use OUT and IN OUT parameter in the function.
Re: OUT & IN OUT [message #287555 is a reply to message #287553] Wed, 12 December 2007 11:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can we use OUT and IN OUT parameter in the function.
Can we? Yes
Should you? NO!
Re: OUT & IN OUT [message #287556 is a reply to message #287553] Wed, 12 December 2007 11:47 Go to previous messageGo to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
When we can use it, then why should not we use it.Is there any strong reason why we should not use it,please explain

Thanks,
Srinivas
Re: OUT & IN OUT [message #287560 is a reply to message #287553] Wed, 12 December 2007 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes you can (syntaxically) and yes you can (logically).
Some said you should not, I say if you want.
The most important point is to document when you can use it and you must not.

Regards
Michel
Re: OUT & IN OUT [message #287561 is a reply to message #287553] Wed, 12 December 2007 12:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://en.wikipedia.org/wiki/Function_%28computer_science%29
the classic/formal definition of a functions says that a single value is RETURNED by the function.
IMO, when more than 1 value can be returned, then a procedure should be used.
Re: OUT & IN OUT [message #287569 is a reply to message #287561] Wed, 12 December 2007 12:55 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Most of standard C functions does not wotk that way.
They return a "return code" as the function value and data in out parameters.

Regards
Michel
Previous Topic: Need 10g RAC training
Next Topic: join
Goto Forum:
  


Current Time: Wed Nov 27 11:00:37 CST 2024