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