crystal reports 9 - oracle stored procedure returning REF CURSOR error

[Former Member]

I am using crystal reports 9 . I have created a stored procedure returning a ref cursor. It works fine in oracle. I tried calling the stored procedure in a pl/sql block it did return the expected number of records. I was caught up with when it gave me error when using the stored procedure in crystal report. I tried with different drivers

The stored procedure does not accept any input, only one OUT parameter as a REF CURSOR

Oracle in OraClient10gHome1 - error canot pass null to a not null constrained formal parameter

CR oracle ODBC driver 5.3- error wrong number or types of arguments in call to the procedure

CR oracle ODBC driver 4.10 - error wrong number or types of arguments in call to the procedure

Microsoft ODBC for oracle- Oracle ODBC driver: syntax error or access violation

Procedure was successful in oracle

SQL> declare

2 x2 sys_refcursor;

3 v_rec tab_award_2010%rowtype;

4 begin

5 bcpaward(x2); -- call to the stored procedure

6 loop

7 fetch x2 into v_rec;

8 dbms_output.put_line(v_rec.donor_id);

9 exit when x2%notfound;

10 end loop;

11

12 end;

13 /

63896

63896

PL/SQL procedure successfully completed.

anybody have suggesstions. kinldy help me out

[former_member11696 · Accepted solution]

Good morning,

If you search the Knowledge base system you would have found this article on [how to|http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/1084c536-711e-2b10-e48a-924a60745253]... and the requirements CR needs in a Oracle SP.

Thank you

Don