sys_refcursor pre 9i

[alexhu]

I have code to create a procedure

create or replace procedure SP_RSV
( warehouse 	IN  STSTYL00.ST00_COM_DIV%TYPE,
  startpoint	IN  PXSTYL00.PX00_DCR%TYPE,
  endpoint	IN  PXSTYL00.PX00_DCR%TYPE,
o_result_set	OUT sys_refcursor) IS
BEGIN
    OPEN o_result_set FOR............

however sys_refcursor is for 9i and I need to use this on 8.0.5

Anyone any ideas how to go backwards ?

Alex

 

[alexhu]

found the solution

create or replace package types
as
 type cursortype is ref cursor;
end;


create or replace procedure SP_RSV
( warehouse 	IN  STSTYL00.ST00_COM_DIV%TYPE,
  startpoint	IN  PXSTYL00.PX00_DCR%TYPE,
  endpoint	IN  PXSTYL00.PX00_DCR%TYPE,
o_result_set	OUT types.cursortype) IS
BEGIN
    OPEN o_result_set FOR.............

Alex