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

SET_REPORT_OBJECT_PROPERTY Built-in

Description

Programmatically sets the value of a report property.

Syntax

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_id REPORT_OBJECT,
property
NUMBER,
value VARCHAR2
);

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_name VARCHAR2,
property
NUMBER,
value VARCHAR2
);

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_id REPORT_OBJECT,
property
NUMBER,
value NUMBER
);

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_name VARCHAR2,
property
NUMBER,
value NUMBER
);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

report_id 
 
Specifies the unique ID of the report. You can get the report ID for a particular report using FIND_REPORT_OBJECT .
 
report_name 
 
Specifies the unique name of the report.
 
property 
 
One of the following constants:
 
REPORT_EXECUTION_MODE: The report execution mode, either BATCH or RUNTIME

 REPORT_COMM_MODE: The report communication mode, either SYNCHRONOUS or ASYNCHRONOUS

 REPORT_DESTYPE: The report destination type, either PREVIEW, FILE, PRINTER, MAIL, CACHE or SCREEN

 One of the following strings:

 REPORT_FILENAME: The report filename

 REPORT_SOURCE_BLOCK: The report source block name

 REPORT_QUERY_NAME: The report query name

 REPORT_DESNAME: The report destination name

 REPORT_DESFORMAT: The report destination format

 REPORT_SERVER: The report server name

 REPORT_OTHER: The other user-specified report properties

value  

One of the following constants:

 REPORT_EXECUTION_MODE: Value must be BATCH or RUNTIME

 REPORT_COMM_MODE: Value must be SYNCHRONOUS or ASYNCHRONOUS

 REPORT_DESTYPE: Value must be PREVIEW, FILE, PRINTER, MAIL, CACHE, SCREEN, FTP, WEBDAV, ORACLEPORTAL, ORACLEWIRELESS, SECUREPDF, or BLOBDESTINATION

 One of the following strings:

 REPORT_FILENAME: Value must be of type VARCHAR2

 REPORT_SOURCE_BLOCK: Value must be of type VARCHAR2

 REPORT_QUERY_NAME: Value must be of type VARCHAR2

 REPORT_DEST_NAME: Value must be of type VARCHAR2

 REPORT_DEST_FORMAT: Value must be of type VARCHAR2

 REPORT_SERVER: Value must be of type VARCHAR2

 REPORT_OTHER: Value must be of type VARCHAR2

Usage Notes

SET_REPORT_OBJECT_PROPERTY Examples

DECLARE
 repid REPORT_OBJECT;
 report_prop VARCHAR2(20);
BEGIN
 repid := find_report_object('report4');
 SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, BATCH);
 SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, SYNCHRONOUS);
 SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, FILE);
END;