how to run procedure containig REF CURSOR as datatype

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Mon, 04 Jun 2001 15:34:35 -0700
Message-ID: <F001.0031B337.20010604153532@fatcity.com>

Hi,

What value to pass as io_cursor in the following procedure....How to run the procedures containing REF CURSOR..........

create or replace package GetRateSchedules_pkg as

         TYPE t_cursor is REF CURSOR;
         procedure GetRateSchedules( temp_id_acc int,acc_cycle_id

int,default_pl int,RecordDate date,temp_id_pi_type int,io_cursor in out t_cursor);

         end;

i am getting error when i run the following code:

 declare
 TYPE t_cursor is REF CURSOR;
 io_cursor t_cursor;
 begin
 getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor);  end;
 /

ORA-01790: expression must have same datatype as corresponding expression.........

Thanks
Harvinder
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 04 2001 - 17:34:35 CDT