RE: Recursive Function

From: Jared Still <jkstill_at_cybcon.com>
Date: Sun, 09 May 2004 09:36:14 -0700
Message-Id: <1084120574.15775.1897.camel@poirot>

On Sun, 2004-05-09 at 07:12, Jamadagni, Rajendra wrote:
> In oracle functions you can have in/out parameters to a Function ... It
> is perfectly legal, but we are not *taught* that way ... That is the
> problem. No one *teaches* us to "think outside the box".
>

I've considered using in/out from a function, but then used a procedure instead.

The idea of using a function to both return a value and modify its arguments seems like it would cause difficulty in following program flow.

Maybe I just haven't encountered a situation where using this functionality would save the day.

At the current rate with Sarbanes Oxley to greet me every day, I may never get the opportunity to find out. At least it feels that way by Friday.

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun May 09 2004 - 11:28:29 CDT