DOWNLOAD Procedure Signature 2

30.2 DOWNLOAD Procedure Signature 2

This procedure downloads a CLOB to the client.

Note:

Clears any previous output to the HTP buffer. APEX_APPLICATION.STOP_APEX_ENGINE is called after downloading the file.

Syntax

APEX_HTTP.DOWNLOAD (
    p_clob              IN OUT NOCOPY   CLOB,
    p_content_type      IN              VARCHAR2,
    p_filename          IN              VARCHAR2     DEFAULT NULL,
    p_is_inline         IN              BOOLEAN      DEFAULT FALSE )

Parameters

Parameter	Description
`p_clob`	The CLOB value to download.
`p_content_type`	The mime type of the file.
`p_filename`	Name of the file.
`p_is_inline`	If `FALSE` (default), the browser displays a file download dialog to save the file. If `TRUE`, displays the file inline in the browser window.

Example

The following example downloads a text.

DECLARE
    l_text   clob;
BEGIN

    l_text := 'Hello World';

    apex_http.download(
        p_clob           => l_text,
        p_content_type   => 'text/plain',
        p_filename       => 'hello.txt' );

END;

Parent topic: APEX_HTTP