41.13 IMPORT_TEXT_MESSAGES Procedure Signature 2

Imports text messages for an application for all files contained in the ZIP supplied.

Syntax

APEX_LANG.IMPORT_TEXT_MESSAGES (
    p_application_id     IN   NUMBER,
    p_zip_file           IN   BLOB )

Parameters

Parameter	Description
p_application_id	Application ID of the primary application.
p_zip_file	The zipped blob data to import.

Example

The following example imports a ZIP file from a table and applies it 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 as a zip file
    for c1 in ( select application_id,
                       translation_zip_file
                from   my translation_table
                where  translation_app_id = 100 )
     loop
         apex_lang.import_text_messages(
             p_application_id             => c1.application_id
             p_zip_file                   => c1.translation_zip_file );
     end loop;
     commit;
end;