This discussion is archived
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 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points