Integration

Hi
I am getting the FRM-40733:PL/SQL built-in DBMS_ERROR_CODE failed, when I am trying to search a form FORM1.

It was working fine before I developed another form FORM2. The new form FORM2 contains a push button to create a report.

Event after deploying the new form FORM2, the FORM1 was working fine. But after few days this error is occuring

could you please tell me how to resolve this error?

10.1.2.0.2 version of AS is installed.


I have written the following code in the push button.


declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
List_id ParamList;
begin


List_id := GET_PARAMETER_LIST('input_params');
IF NOT ID_NULL(List_id) THEN
DESTROY_PARAMETER_LIST(List_id);
END IF;
List_id := Create_Parameter_List('input_params');


Add_Parameter(List_id, 'column1',TEXT_PARAMETER,value1);
Add_Parameter(List_id, 'column2',TEXT_PARAMETER,value2);
Add_Parameter(List_id, 'column3',TEXT_PARAMETER,value3);

repid := FIND_REPORT_OBJECT('rep1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,'/u/10gAS/reports/report_file.rdf');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,FILE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'/u/10gAS/reports/report1.pdf');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'report_server_10g');

v_rep := RUN_REPORT_OBJECT(repid, List_id);
Destroy_Parameter_List(List_id);
end;


regards