how to execute ref cursor using dynamic sql

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 06 Jun 2001 10:53:46 -0700
Message-ID: <F001.0031EB0E.20010606104642@fatcity.com>

Hi,
I got the following code from metalink whci says we can't use ref cursor directly in
dynamic sql earlier than 9i..
but following code don't seems like working: error is
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at line 22
execute immediate 'declare v_cursor getrateschedules_pkg.t_cursor; begin open v_cursor for select * from TempEff end;'; how to run this code...
Thanks
Harvinder Received on Wed Jun 06 2001 - 12:53:46 CDT