frm-41211 integration error: SSL failure running another product
Dear all i am using Forms Reports 10g.
I have a report which i have to call in my form with some parameters .
But when i try to call the report then it is showing Error .
And the error is :-
frm-41211 integration error: SSL failure running another product
Then another error is :-
FRM-40738 Argument1 to builtin REPORT_OBJECT_STATUS cannot be null 2
And imy requirment is when i press the print button it should print and should disply in PDF format.
Please help me.
My code is :-
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
vParamValue number;
BEGIN
plid := Get_parameter_List('tmp');
IF NOT Id_Null(plid) THEN
Destroy_parameter_List( plid );
END IF;
plid := Create_parameter_List('tmp');
Add_Parameter(PLid, 'P_Block', Text_Parameter, :block_query.item_block);
Add_Parameter(PLid, 'P_Category', Text_Parameter, :block_query.item_category);
Add_Parameter(PLid, 'P_Dept', Text_Parameter, :block_query.item_dept);
Add_Parameter(PLid, 'P_FLOOR', Text_Parameter, :block_query.item_floor);
Add_Parameter(PLid, 'P_IP', Text_Parameter, :block_query.item_ip);
Add_Parameter(PLid, 'P_Room', Text_Parameter, :block_query.item_room);
Add_Parameter(PLid, 'P_Userid', Text_Parameter, :block_query.item_usr_id);
Add_Parameter(PLid, 'PARAMFORM', Text_Parameter, 'NO');
repid := FIND_REPORT_OBJECT('REPORT_test1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,cache);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER, 'paramform=no');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_a_f2_itt_pc_4');
v_rep := RUN_REPORT_OBJECT(repid,plid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
WEB.SHOW_DOCUMENT('http://A_F2_ITT_PC_4.AAHOS.LOCAL:8890/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?
'||'server=rep_a_f2_itt_pc_4&P_parameter='||'&block='''||:block_query.item_block
||'&category_name='''||:block_query.item_category
||'&dept='''||:block_query.item_dept
||'&floor='''||:block_query.item_floor
||'&ip_address='''||:block_query.item_ip
||'&room='''||:block_query.item_room
||'&usr_id='''||:block_query.item_usr_id
||'¶mform=no');
End;