1 Reply Latest reply: Dec 8, 2012 9:12 AM by Denis Segard-Oracle RSS

    How to stop the report ouput in cache folder in oracle reports 11g

    benz
      Hi,
      I am using the below code to generate the report ouput in the particular directory, it's work fine it's generate in the specified path folder but also same time it generate the report output in reports cache folder.
      What to do if we specify the destype= FILE the report output should not generate in cache but it's should only generate the in that specified folder only.


      Procedure report_out
      ( report_name varchar2,
      p_paramlist ParamList) is
      v_repid report_object;
      v_output_file varchar2(100);
      V_status varchar2(100);
      v_report_status varchar2(100);
      begin
      v_repid := FIND_REPORT_OBJECT ('olbj');
      v_output_file:='d:\reports||'\'||report_name';
      set_report_object_property(v_repid,REPORT_EXECUTION_MODE,RUNTIME);
      set_report_object_property(v_repid,REPORT_COMM_MODE,SYNCHRONOUS);
      SET_REPORT_OBJECT_PROPERTY (v_repid, report_destype, FILE);     
      set_report_object_property(v_repid,REPORT_FILENAME,report_name);
      set_report_object_property(v_repid,REPORT_DESNAME,v_output_file);
      SET_REPORT_OBJECT_PROPERTY (v_repid, report_desformat, 'pdf');
      SET_REPORT_OBJECT_PROPERTY (v_repid, report_server, 'rept_servername');
      vrep := RUN_REPORT_OBJECT (v_repid, v_parameterlist_id);
      v_report_status := REPORT_OBJECT_STATUS (V_status);
      WHILE v_report_status IN ('RUNNING', 'OPENING_REPORT', 'ENQUEUED')
      LOOP
      v_report_status := REPORT_OBJECT_STATUS (vrep);
      END LOOP;
      END;

      Thanks in advance.
        • 1. Re: How to stop the report ouput in cache folder in oracle reports 11g
          Denis Segard-Oracle
          Hello,

          It is not possible ...

          The file in the Reports Server cache directory is created by the Reports Engine .
          The file created in the Reports Server cache is used by the Reports Server in order to "execute" the DESTYPE .

          You can use the parameter EXPIRATION in order to delete the file from the Reports Server cache after a certain amount of time :
          http://docs.oracle.com/cd/E14571_01/bi.1111/b32121/pbr_cla006.htm#autoId5

          You can write your own "Destination Class" that will replace the standard class used for DESTYPE=FILE (oracle.reports.server.DesFile)

          http://docs.oracle.com/cd/E14571_01/bi.1111/b32121/pbr_conf002.htm#autoId6

          See http://www.oracle.com/technetwork/middleware/reports/index-085705.html
          for example of custom destinations.

          Regards