3 Replies Latest reply: Jan 15, 2013 1:14 PM by JL_Styberg RSS

    Calling report causes REP-546: The value for parameter PARM_1 is invalid

    JL_Styberg
      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||'&paramform=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