From Harvinder.Singh@MetraTech.com Wed, 06 Jun 2001 10:53:46 -0700
From: Harvinder Singh <Harvinder.Singh@MetraTech.com>
Date: Wed, 06 Jun 2001 10:53:46 -0700
Subject: how to execute ref cursor using dynamic sql
Message-ID: <F001.0031EB0E.20010606104642@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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