Home » SQL & PL/SQL » SQL & PL/SQL » Out mode in functions
Out mode in functions [message #239440] Tue, 22 May 2007 07:33 Go to next message
Messages: 144
Registered: February 2007
Location: india
Senior Member

Any body help me,

I want a sample program a function return value using OUT mode.

Expecting your replies..
Thanks a lot..

Re: Out mode in functions [message #239441 is a reply to message #239440] Tue, 22 May 2007 07:35 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Don't do it.
Functions should return their data via the RETURN clause.
If you're going to have an OUT parameter, then just make it a Procedure. That way, all your data will come back in the same way.
Having OUT parameters on functions defeats the purpose of using functions in the first place.
Previous Topic: Separate Alpha-Numeric Column into Alpha and Number
Next Topic: TO_CHAR masks for decimal numbers
Goto Forum:

Current Time: Thu Aug 17 12:13:35 CDT 2017

Total time taken to generate the page: 0.06964 seconds