-
How to get a cursor from a dynamic query within a procedure?
Hi all,
I want to execute a dynamic query using "EXECUTE IMMEDIATE" and return the result as a OUT parameter of procedure. I can not use OPEN test_cur FOR..." method so is there any other way to do this?
And what about if I want to do this and return an int from that dynamic query as an OUT param? e.g. a SUM().
-Thanks in advance for your help
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
|
|