CREATE OR REPLACE PACKAGE CR_PACKAGE IS

/***************************************************
This package is used by Crystal Reports V8.5
in order to access Stored Procedures in reports .

*****************************************************/

TYPE CR_CURSOR IS REF CURSOR;

END CR_PACKAGE;






declare
       test_cursor Cr_Package.CR_CURSOR;
       resultset   test_cursor%ROWTYPE;
begin
     Cmqrumir(test_cursor, 'ITEXA',null,null,null,'2007-02-12',null);



if not test_cursor%isopen then
   dbms_output.put_line('the cursor is not open');
else
    dbms_output.put_line('the cursor is open');
end if;


fetch test_cursor into resultset;

/*
--      while test_cursor%found loop
-- dbms_output.put_line(resultset.ID);
--dbms_output.put_line(resultset.Firstname);
--dbms_output.put_line(resultset.Lastname);
--dbms_output.put_line(resultset.Birthday);
--fetch test_cursor into resultset;
--end loop;
*/
end;

ORA-06550: line 3, column 20:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 3, column 20:
PL/SQL: Item ignored
ORA-06550: line 16, column 24:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 16, column 1:
PL/SQL: SQL Statement ignored