Re: How to get a cursor from a dynamic query within a procedure?

baroncrampantc via DBMonster.com wrote:
> 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

Return an array.

And I'd like to know too ... why can't you return a REF CURSORS?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)