A script-enabled browser is required for this page to function properly.

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

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;