EXPORT Function

This function exports the query context in the specified format.

Syntax

FUNCTION EXPORT (
    p_context                   IN wwv_flow_exec_api.t_context,
    p_format                    IN t_format,
    p_as_clob                   IN BOOLEAN                      DEFAULT false,
    p_columns                   IN t_columns                    DEFAULT c_empty_columns,
    p_column_groups             IN t_column_groups              DEFAULT c_empty_column_groups,
    p_aggregates                IN t_aggregates                 DEFAULT c_empty_aggregates,
    p_highlights                IN t_highlights                 DEFAULT c_empty_highlights,
    --          
    p_file_name                 IN VARCHAR2                     DEFAULT NULL,
    p_print_config              IN t_print_config               DEFAULT c_empty_print_config,
    p_page_header               IN VARCHAR2                     DEFAULT NULL,
    p_page_footer               IN VARCHAR2                     DEFAULT NULL,
    p_supplemental_text         IN VARCHAR2                     DEFAULT NULL,
    --          
    p_csv_enclosed_by           IN VARCHAR2                     DEFAULT NULL,
    p_csv_separator             IN VARCHAR2                     DEFAULT NULL,
    --          
    p_pdf_accessible            IN BOOLEAN                      DEFAULT NULL,
    --
    p_xml_include_declaration   IN BOOLEAN                      DEFAULT false ) 
    RETURN t_export

Parameters

Parameter	Description
`p_context`	Context object from the EXEC infrastructure.
`p_format`	Export format. Valid values are: XLSX, PDF, HTML, CSV, XML and JSON.
`p_as_clob`	Exports as a CLOB instead of BLOB (default FALSE).
`p_columns`	Collection of column attributes beginning with column breaks, then in the order of display.
`p_column_groups`	Collection of column group attributes in the order of levels and display.
`p_aggregates`	Collection of report aggregates.
`p_highlights`	Collection of report highlights.
`p_file_name`	Defines the filename of the export.
`p_print_config`	Used for EXCEL and PDF to set the print attributes.
`p_page_header`	Text to appear in the header section of the document. Overrides the page header from `p_print_config`.
`p_page_footer`	Text to appear in the footer section of the document. Overrides the page footer from `p_print_config`.
`p_supplemental_text`	Text at the top of all download formats.
`p_csv_enclosed_by`	Used for CSV to enclose the output.
`p_csv_separator`	Used for CSV to separate the column values.
`p_pdf_accessible`	Used for PDF to create an accessible PDF.
`p_xml_include_declaration`	Used for XML to generate the XML declaration as the first line.

Returns

This function returns: the export file as object which includes the contents, MIME type, and file name.

Examples

DECLARE
    l_context apex_exec.t_context; 
    l_export  apex_data_export.t_export;
BEGIN
    l_context := apex_exec.open_query_context(
        p_location    => apex_exec.c_location_local_db,
        p_sql_query   => 'select * from emp' );

    l_export := apex_data_export.export (
                        p_context   => l_context,
                        p_format    => apex_data_export.c_format_pdf );

    apex_exec.close( l_context );

    apex_data_export.download( p_export => l_export );

EXCEPTION
    when others THEN
        apex_exec.close( l_context );
        raise;
END;