Re: SQLForms FUNCTION Capability (followup)

From: David Bath <dtb_at_otto.bf.rmit.oz.au>
Date: 14 Apr 93 06:54:48 GMT
Message-ID: <dtb.734770488_at_otto>


fgreene_at_hayes.com writes:

>
> NOTE: Anything that can be done with a Function, can also be
> done with a Procedure which includes an OUT parameter
> to return the desired value. Anything that can be done
> with a Procedure, can also be performed with a Function
> whose RETURN value reports the status of the task
> performed. So, while the syntax of a Procedure and a
> Function differs slightly, a particular task can be
> done via a PL/SQL Procedure or Function based on the
> syntax which the designer deems most convenient.
No, what if you want to "return" two things. This implies two formal arguments declared as OUT. You cannot do this functions as the doco (kindly bounced to the news by frank) says no OUTs declared for functions

-- 
David T. Bath             | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
Senior Tech Consultant    | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
Global Technology Group   | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
"The robber of your free will does not exist" - Epictetus
Received on Wed Apr 14 1993 - 08:54:48 CEST

Original text of this message