Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL function as a parameter to another PL/SQL function?
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
![]() |
![]() |