RUN_REPORT_OBJECT Built-in
Description
Use this Built-in to run a report from within a form. You can run the report
against either a local or remote database server.
Syntax
FUNCTION RUN_REPORT_OBJECT
(report_id REPORT_OBJECT);
FUNCTION RUN_REPORT_OBJECT
(report_name VARCHAR2);
FUNCTION RUN_REPORT_OBJECT
(report_id REPORT_OBJECT,
paramlist_name VARCHAR2);
FUNCTION RUN_REPORT_OBJECT
(report_id REPORT_OBJECT,
paramlist_id PARAMLIST);
FUNCTION RUN_REPORT_OBJECT
(report_name VARCHAR2,
paramlist_name VARCHAR2);
FUNCTION RUN_REPORT_OBJECT
(report_name VARCHAR2,
paramlist_id PARAMLIST);
Built-in Type unrestricted procedure
Returns VARCHAR2
Enter Query Mode yes
Parameters
- report_id
- Specifies the unique ID of the report to be run. You can get the report
ID for a particular report using the Built-in FIND_REPORT_OBJECT
-
- report_name
-
- The name of the report object to run.
-
- paramlist_name
-
- The name you gave the parameter list object when you defined it. Datatype
is VARCHAR2.
-
- paramlist_id
-
- The unique ID Oracle Forms assigns when it creates the parameter list.
Datatype is PARAMLIST.
Usage Notes
- Returns a VARCHAR2 value that uniquely identifies the report that is running
either locally or on a remote report server. You can use this report ID string
as a parameter to REPORT_OBJECT_STATUS
, COPY_REPORT_OBJECT OUTPUT
, and CANCEL_REPORT_OBJECT.
- If you invoke RUN_REPORT_OBJECT with a blank Reports
Server property, the return value will be NULL.
In that case, you cannot then use the Built-ins REPORT_OBJECT_STATUS and COPY_REPORT_OBJECT_OUTPUT
because they require an actual ID value.
RUN_REPORT_OBJECT 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);
...
END;