rasikaw
08-10-2005, 04:48 AM
Hello,
I want to pass a list of proc names along with their arguments to a parent proc. The parent proc then needs to dynamically call the procs one-by-one passing in the params for each proc, and then return REF CURSORs (there is a single OUT REF CURSOR paramer for each proc) back to the caller (in this case the data access layer of the application).
Is this possible?
Rasika.
I want to pass a list of proc names along with their arguments to a parent proc. The parent proc then needs to dynamically call the procs one-by-one passing in the params for each proc, and then return REF CURSORs (there is a single OUT REF CURSOR paramer for each proc) back to the caller (in this case the data access layer of the application).
Is this possible?
Rasika.