Skip to Content
0
Former Member
Jan 25, 2011 at 08:40 PM

crystal reports 9 - oracle stored procedure returning REF CURSOR error

246 Views

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