41.8 EXPORT_TEXT_MESSAGES Function Signature 2

This function returns a ZIP file containing translation files for each translation mapping in the format supplied.

Syntax

APEX_LANG.EXPORT_TEXT_MESSAGES  (
    p_application_id     IN   NUMBER,
    p_format             IN   t_export_format  DEFAULT c_export_format_xliff )
    RETURN blob;

Parameters

Parameter	Description
p_application_id	Application ID of the primary application.
p_format	Format for internal zipped files (c_export_format_xliff or c_export_format_csv).

Returns

Blob containing a ZIP file.

Example

The following example exports text messages for all language mappings for an existing Oracle APEX application.

declare
      l_zip blob;
begin
    --
    -- If running from SQLcl, we need to set the environment
    -- for the Oracle APEX workspace associated with this schema.
    -- The call to apex_util.set_workspace is not necessary
    -- if you're running within the context of the App Builder
    -- or an APEX application.
    --
    apex_util.set_workspace( 'MY_WORKSPACE' );

    -- Now, export text messsage as a zip file for all language mappings in the format required
    l_zip := apex_lang.export_text_messages(
        p_application_id             => 100,
        p_format                     => apex_lang.c_export_format_xliff );
end;