41.12 IMPORT_TEXT_MESSAGES Procedure Signature 1

This function imports text messages for an application for the language and format supplied.

Syntax

APEX_LANG.IMPORT_TEXT_MESSAGES (
    p_application_id     IN   NUMBER,
    p_file               IN   CLOB,
    p_format             IN   t_export_format  DEFAULT c_export_format_xliff );

Parameters

Parameter	Description
p_application_id	Application ID of the primary application.
p_file	The clob data to import.
p_format	Format of the clob data (c_export_format_xliff or c_export_format_csv).

Example

The following example imports some translation files from a table and applying them to an existing Oracle APEX application.

begin
    --
    -- If running from SQLcl, we need to set the environment
    -- for the 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, import text messsage files
    for c1 in ( select application_id,
                       translation_file,
                       translation_format
                from   my translation_table
                where  translation_app_id = 100 )
     loop
         apex_lang.import_text_messages(
             p_application_id         => c1.application_id
             p_file                   => c1.translation_file
             p_format                 => c1.translation_format);
     end loop;
     commit;
end;