COPY_REPORT_OBJECT_OUTPUT Built-in
Description
Copies the output of a report to a file.
Syntax
PROCEDURE COPY_REPORT_OBJECT_OUTPUT
(report_id VARCHAR2(20),
output_file VARCHAR2
);
Built-in Type unrestricted procedure
Enter Query Mode yes
Parameters
- report_id
-
- The VARCHAR2 value returned by the RUN_REPORT_OBJECT
Built-in. This value uniquely identifies the report that is currently running
either locally or on a remote report server.
-
- output_file
-
- The name of the file where the report output will be copied.
Usage Notes
- Use the Report Destination Type property to specify the format of the output file.
- To copy the output of a report from a remote machine, you must set the Report Destination Type property to Cache.
COPY_REPORT_OBJECT_OUTPUT Examples
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
repid := find_report_object('report4');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := report_object_status(v_rep);
if rep_status = 'FINISHED' then
message('Report Completed');
copy_report_object_output(v_rep,'d:/temp/local.pdf');
host('netscape d:/temp/local.pdf');
else
message('Error when running report.');
end if;
END;