Dynamically calling procedures AND returning REF CURSORs

[rasikaw]

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.

[padders]

What version of Oracle? What parameters need to be passed? Proper example would not go amiss.