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 iscalled 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;