41.7 EXPORT_TEXT_MESSAGES Function Signature 1

Returns a file containing text messages for translation for the language code supplied.

Syntax

APEX_LANG.EXPORT_TEXT_MESSAGES (
    p_application_id     IN   NUMBER,
    p_lang_code          IN   VARCHAR2,
    p_format             in   t_export_format  DEFAULT c_export_format_xliff )
    RETURN clob;

Parameters

Parameter	Description
p_application_id	Application ID of the primary application.
p_lang_code	The IANA language code for the existing translation mapping (such as en-us, fr-ca, ja, he).
p_format	Format for the file (c_export_format_xliff or c_export_format_csv).

Returns

A clob containing file in the format supplied.

Example

The following example demonstrates exporting text messages for a language mapping for an existing APEX application.

declare
      l_file clob;
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 in the language and format required
    l_file := apex_lang.export_text_messages(
        p_application_id             => 100,
        p_lang_code                  => 'fr',
        p_format                     => apex_lang.c_export_format_csv );
end;