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
