Skip to Content
0
Former Member
Apr 17, 2009 at 11:09 AM

DB2 Stored Procedure Results Error

23 Views

Hi Dudes,

I could able to connect the db2 stored procedure in crystal report 11 successfully without error.However my problem is, i could not able to view the result even though i pass the correct parameter.

Here is the snippet

CREATE PROCEDURE SP_CTYPING ( IN V_CO VARCHAR(3) ) 
LANGUAGE SQL 

BEGIN 

DECLARE C1 CURSOR FOR select  * from fafcty a inner join ccfcty cl on cl.co_f=a.clnt_f
WHERE INSL_CO_C= V_CO; 

OPEN C1 ; 

END

In crystal report i can able to connect this procedure without any error. I can see all fields of both fafcty,ccfcty tables at crystal report. When i try to run the report with correct parameter value, it returns empty record. Plz help to solve this error.

Thanks in Advance,

Suresh