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

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

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;