GET_PRINT_DOCUMENT Function Signature 2

This function returns a document as BLOB using pre-defined report query and pre-defined report layout.

Syntax

APEX_UTIL.GET_PRINT_DOCUMENT (
    p_application_id      IN NUMBER,
    p_report_query_name   IN VARCHAR2,
    p_report_layout_name  IN VARCHAR2 default null,
    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

Table 21-50 describes the parameters available in the GET_PRINT_DOCUMENT function.

---

Table 21-50 GET_PRINT_DOCUMENT Signature 2 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_name	Name of the report layout (stored under application's Shared Components)
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.

---

For a GET_PRINT_DOCUMENT example see "GET_PRINT_DOCUMENT Function Signature 4".