DB2 Stored Procedure Results Error
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,