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". Raj ------------------------------------------------------------------------ --------=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 select standard_disclaimer from company_requirements;=20 QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared.Still@xxxxxxxxxxx Sent: Thursday, May 06, 2004 8:37 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Recursive Function > 1. ... is better to have only one return That is not necessarily true. It depends on which guru you listen to. Steven Feuerstein says 'only one return'. Larry Wall says 'why?'. I agree with Larry. I've written convoluted code in the past to try and use the 'only 1 return' rule, and decided it was silly. Use what works best for the language you're programming in. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------