Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL function as a parameter to another PL/SQL function?

Re: PL/SQL function as a parameter to another PL/SQL function?

From: Martin Schroeder <ms_at_dream.hb.north.de>
Date: 1997/05/07
Message-ID: <DzOczAMOBh108h@dream.hb.north.de>#1/1

In <3371d278.13991168_at_newshost> tkyte_at_us.oracle.com (Thomas Kyte) writes:
>On 6 May 1997 21:15:14 GMT, "Brian Gastineau" <bgastine_at_giveblood.org> wrote:
 

>>Can a PL/SQL function be passed into another PL/SQL function? My situation
>>is that during conversion of data, several different tests will be run
>>against each record, but the response to the true/false condition will be
>>the same.
>>
>>Suggestions for workarounds would also be appreciated.
>>
>>Thanks,
>>Brian Gastineau
>>bgastine_at_giveblood.org
 

>Yes, pl/sql functions may be used as IN parameters to other pl/sql functions,
>for example:

[Example of use of functions in expression snipped]

What Thomas means is called 'procedure variable' in Modula-2 and 'function pointer' in C.

AFAIK it's impossible in PL/SQL.

Best regards

        Martin

-- 
               Martin Schr"oder, MS_at_Dream.HB.North.DE
They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. (Benjamin Franklin)
Received on Wed May 07 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US