58.63 GET_PRINT_DOCUMENT Function Signature 3

This function returns a document as BLOB using a pre-defined report query and RTF or XSL-FO based report layout.

Syntax

APEX_UTIL.GET_PRINT_DOCUMENT (
    p_application_id      IN NUMBER,
    p_report_query_name   IN VARCHAR2,
    p_report_layout       IN CLOB,
    p_report_layout_type  IN VARCHAR2 DEFAULT 'xsl-fo',
    p_document_format     IN VARCHAR2 DEFAULT 'pdf',
    p_print_server        IN VARCHAR2 DEFAULT NULL )
RETURN BLOB;

Parameters

Parameter Description
p_application_id Defines the application ID of the report query.
p_report_query_name Name of the report query (stored under application's shared components).
p_report_layout Defines the report layout in XSL-FO or RTF format.
p_report_layout_type Defines the report layout type, that is "xsl-fo" or "rtf".
p_document_format Defines the document format, that is "pdf", "rtf", "xls", "htm", or "xml".
p_print_server URL of the print server. If not specified, the print server is derived from preferences.

Example

For a GET_PRINT_DOCUMENT example see GET_PRINT_DOCUMENT Function Signature 4.