Calling report causes REP-546: The value for parameter PARM_1 is invalid
Hello,
I am running Forms/Reports 11.1.2 on Windows XP with an 11.2.0.2 database on Windows 2008.
I can successfully run a report from forms when there are no user defined parameters sent. However, when I attempt to send a parameter, it gives me the REP-546 error message on the ...reports/rwservlet/showjobs. I cannot find any information on this error that pertains to my circumstances.
This is the report call from Forms:
v_report_id := FIND_REPORT_OBJECT('REPORT13');
v_rep_server := 'rep_adminserver_is-4_inst';
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,v_rep_server);
v_un_pw := '&userid=' ||GET_APPLICATION_PROPERTY(username)||'/'||
GET_APPLICATION_PROPERTY(password)||'@'||
GET_APPLICATION_PROPERTY(connect_string);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'PARM_1='||:PARM.shoporder||v_un_pw||'¶mform=no');
--
vc_report_job := RUN_REPORT_OBJECT(v_report_id);
sJob := SUBSTR(vc_report_job,LENGTH(v_rep_server)+2);
--
vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job);
WHILE vc_rep_status IN ('RUNNING','OPENING_REPORT','ENQUEUED', NULL) LOOP
vc_rep_status:=REPORT_OBJECT_STATUS(vc_report_job);
END LOOP;
IF vc_rep_status = 'FINISHED' THEN
web.show_document('http://is-4:7001/reports/rwservlet/getjobid='||
sJob ||'?server='||v_rep_server,'_blank');
ELSE
MESSAGE('Report failed with error message '||vc_rep_status);
END IF;
where :PARM.shoporder is a data field in the form.
Any advice is appreciated.
Jan