-
Dynamically calling procedures AND returning REF CURSORs
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.
-
What version of Oracle? What parameters need to be passed? Proper example would not go amiss.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|