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

REPORT_OBJECT_STATUS Built-in

Description

Provides status of a report object run within a form by the RUN_REPORT_OBJECT Built-in.

Syntax

FUNCTION REPORT_OBJECT_STATUS
(report_id VARCHAR2(20));

Built-in Type unrestricted function

Return Type VARCHAR2

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.

Usage Notes

There are eight possible return values for this Built-in:

The generic error message ERROR is returned for any other case.

REPORT_OBJECT_STATUS Example

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;