Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB2 Stored Procedure Results Error

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question