PL/SQL: Dynamically calling a function., Need help

From: Allard Siemelink <aj_at_knoware.nl>
Date: 1997/04/16
Message-ID: <aj.26.000CF4D7@knoware.nl>#1/1

Hi,
We're currently working on a large project and need to call stored procedures and functions dynamically from PL/SQL. All functions have the same input and output parameters and return a number. e.g.:

function ruleX (an_object_id in number,

                as_error_msg out varchar) return number

begin
  --BODY
end;

Is it possible to call such a function dynamically? (Meaning retrieving the name of the function from a database column into a local varchar variable, compose the function call syntax 'execute ruleX(...)' in a varchar variabele and then call it) And if it is, could some kind soul provide an example showing how to call such a function, passing the input parameters and retrieving the output parameters and return value?

TIA, -Allard Received on Wed Apr 16 1997 - 00:00:00 CDT