CREATE OR REPLACE PACKAGE test_pack
IS
   type ref_cur_type is ref cursor;
   function poluchi_cursor (v_test in varchar2) return ref_cur_type;
   pragma restrict_references (poluchi_cursor, wnds);
END  test_pack;
/

CREATE OR REPLACE PACKAGE BODY  test_pack
AS
   function  poluchi_cursor (v_test in varchar2) return ref_cur_type as
      c ref_cur_type;
   begin
      open c for v_test;
      return c;
   end;
END test_pack;
/