using in crystal

Hello,

I see that I should declare stored procedure, when it's first parameter is in out parameter.

I have Oracle 9i.
I have Crystal 9.

I have a problem., when running,
I get the message : ORA-01002.

The procedure, I use in crystal :
CREATE OR REPLACE procedure TEST_GEN(p_cur in out s_general.cur_int, p_int1 in varchar2) is

cur_ref s_general.cur_int;

begin

open p_cur for

  select p_int1 from dual;

end;

/

The s_general package :

CREATE OR REPLACE package S_GENERAL is

rep_last_date date;

dummyInt number;

TYPE cur_int IS REF CURSOR;

end package;

Why is the above ORA-01002 problem ?

Thanks :) Received on Mon May 15 2006 - 07:53:30 CDT