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

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200604/1