Provides status of a report object run within a form by the RUN_REPORT_OBJECT Built-in.
FUNCTION REPORT_OBJECT_STATUS
(report_id VARCHAR2(20));
Built-in Type unrestricted function
Return Type VARCHAR2
Enter Query Mode yes
There are eight possible return values for this Built-in:
The generic error message ERROR is returned for any other case.
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;