Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM-41214 Unable to run report

468734Nov 4 2006 — edited Nov 6 2006
Hi all,

I have a parameter form where user enter to parameter and click OK button to call out a report.

However I got this error: FRM-41214 Unable to run report

My code for the WHEN-BUTTON-PRESSED button as below:

Please help!! TQ

DECLARE
pl_id ParamList;
repid REPORT_OBJECT;
v_rep varchar2(100);
v_server VARCHAR2(100);
rep_status varchar2(100);
v_host VARCHAR2(100);

BEGIN

v_server := 'rep_user-faf4251ef8';
v_host := 'user-faf4251ef8:8889';
pl_id := Get_Parameter_List('tmpdata');


IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;

pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id,'FROMDT',TEXT_PARAMETER,:LS.FRDT);
Add_Parameter(pl_id,'TODATE',TEXT_PARAMETER,:LS.TODT);
Add_Parameter(pl_id,'STAFFID',TEXT_PARAMETER,:LS.STAFFID);
ADD_PARAMETER(pl_id,'TITLE',TEXT_PARAMETER,:LS.TITLE);
repid := find_report_object('rep1');

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,'R1');

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'HTML');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_server);
--SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=YES');

v_rep := RUN_REPORT_OBJECT(repid, pl_id);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
message('Running');
END LOOP;
IF rep_status = 'FINISHED' or rep_status is NULL THEN

WEB.SHOW_DOCUMENT('http://'||v_host||'/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_server,'_b lank');
ELSE
null;
END IF;
END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2006
Added on Nov 4 2006
4 comments
603 views