1 Reply Latest reply: Jul 30, 2009 4:42 PM by 436366 RSS

    RUN_REPORT_OBJECT not working

    644348
      Hi
      I want call a Report from foem9i .
      I use RUN_REPORT_OBJECT but I had a Error that's REP-0503

      My code is

      DECLARE
                     repid REPORT_OBJECT;
                     v_rep VARCHAR2(100);
                     rep_status VARCHAR2(20);
      BEGIN
                     repid := FIND_REPORT_OBJECT('N');
           _/in this line return null/     vrep := RUN_REPORT_OBJECT(repid);
                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;
                     IF rep_status = 'FINISHED' THEN
                     WEB.SHOW_DOCUMENT('http://gridctl:7780/reports/rwservlet/getjobid'||
                     substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rep_gridctl_ora_app','_blank');
                     ELSE
                     message('Error when running report'); pause;
                     END IF;
                     PAUSE;
      END;
        • 1. Re: RUN_REPORT_OBJECT not working
          436366
          From the Forms 6i documentation for the RUN_REPORT_OBJECT built-in:
          >
          If you invoke Run_Report_Object with a blank Report Server property, the return value will be NULL. In that case, you cannot then use the built-ins Report_Object_Status and Copy_Report_Object_Output, because they require an actual ID value.