Apex - Import / Export - Dynamic Translations

Apex has no option for exporting Dynamic Translations - you would expect that in the Component Export but alas.
Dynamic Translations are of course included when exporting the entire application, but sometimes you might want to export the translations separately. For instance when you use the translations in a package/view/etc using apex_lang.lang, while the application itself is being updated and not ready for export.

A workaround:

Export the entire application
Open the resulting SQL file in a text editor
Keep the top part, up to and including the "Set Application ID" section
Keep the bottom part, starting from the "post import process" section
In between, keep the Dynamic Translation parts that you want to include

In the (4.2) example below, 2 Dynamic Translations are included:

set define off
set verify off
set feedback off
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK
begin wwv_flow.g_import_in_progress := true; end;
/
 
 
--application/set_environment
prompt  APPLICATION 200 - TEST Application
--
-- Application Export:
--   Application:     200
--   Name:            TEST Application
--   Date and Time:   11:37 Wednesday July 1, 2015
--   Exported By:     TED
--   Flashback:       0
--   Export Type:     Application Export
--   Version:         4.2.2.00.11
--   Instance ID:     63118961488547
--
-- Import:
--   Using Application Builder
--   or
--   Using SQL*Plus as the Oracle user APEX_040200 or as the owner (parsing schema) of the application
 
-- Application Statistics:
--   Pages:                     48
--     Items:                  251
--     Computations:             7
--     Validations:             20
--     Processes:               56
--     Regions:                129
--     Buttons:                 14
--     Dynamic Actions:         27
--   Shared Components:
--     Logic:
--       Items:                 22
--       Processes:              2
--     Navigation:
--       Lists:                  2
--       Breadcrumbs:            1
--       NavBar Entries:         1
--     Security:
--       Authentication:         1
--     User Interface:
--       Themes:                 1
--       Templates:
--         Page:                17
--         Region:              19
--         Label:               11
--         List:                15
--         Popup LOV:            1
--         Calendar:             1
--         Breadcrumb:           1
--         Button:               4
--         Report:              11
--       LOVs:                  10
--     Globalization:
--       Messages:             362
--     Reports:
 
 
--       AAAA       PPPPP   EEEEEE  XX      XX
--      AA  AA      PP  PP  EE       XX    XX
--     AA    AA     PP  PP  EE        XX  XX
--    AAAAAAAAAA    PPPPP   EEEE       XXXX
--   AA        AA   PP      EE        XX  XX
--  AA          AA  PP      EE       XX    XX
--  AA          AA  PP      EEEEEE  XX      XX
prompt  Set Credentials...
 
begin
 
  -- Assumes you are running the script connected to SQL*Plus as the Oracle user APEX_040200 or as the owner (parsing schema) of the application.
  wwv_flow_api.set_security_group_id(p_security_group_id=>nvl(wwv_flow_application_install.get_workspace_id,1250627565129035));
 
end;
/

begin wwv_flow.g_import_in_progress := true; end;
/
begin 

select value into wwv_flow_api.g_nls_numeric_chars from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS';

end;

/
begin execute immediate 'alter session set nls_numeric_characters=''.,''';

end;

/
begin wwv_flow.g_browser_language := 'en'; end;
/
prompt  Check Compatibility...
 
begin
 
-- This date identifies the minimum version required to import this file.
wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2012.01.01');
 
end;
/

prompt  Set Application ID...
 
begin
 
   -- SET APPLICATION ID
   wwv_flow.g_flow_id := nvl(wwv_flow_application_install.get_application_id,200);
   wwv_flow_api.g_id_offset := nvl(wwv_flow_application_install.get_offset,0);
null;
 
end;
/



-- ######### KEEP ALL TILL HERE



--application/shared_components/globalization/dyntranslations
prompt  ...dynamic translations
--
prompt  ......Dynamic Translation 89554917082934522
declare
  h1 varchar2(32767) := null;
  h2 varchar2(32767) := null;
 
begin
 
h1:=h1||'Een test tekst';

h2:=h2||'A test text';

wwv_flow_api.create_dynamic_translation (
  p_id=>89554917082934522 + wwv_flow_api.g_id_offset,
  p_flow_id=>wwv_flow.g_flow_id,
  p_language=>'en',
  p_from=>h1,
  p_to=>h2);
null;
 
end;
/

prompt  ......Dynamic Translation 89555027817937691
declare
  h1 varchar2(32767) := null;
  h2 varchar2(32767) := null;
 
begin
 
h1:=h1||'En nog een test tekst';

h2:=h2||'And another test text';

wwv_flow_api.create_dynamic_translation (
  p_id=>89555027817937691 + wwv_flow_api.g_id_offset,
  p_flow_id=>wwv_flow.g_flow_id,
  p_language=>'en',
  p_from=>h1,
  p_to=>h2);
null;
 
end;
/



-- ######### KEEP ALL BELOW HERE



prompt  ...post import process
 
begin
 
wwv_flow_api.post_import_process(p_flow_id => wwv_flow.g_flow_id);
null;
 
end;
/

--application/end_environment
commit;
commit;
begin
execute immediate 'begin sys.dbms_session.set_nls( param => ''NLS_NUMERIC_CHARACTERS'', value => '''''''' || replace(wwv_flow_api.g_nls_numeric_chars,'''''''','''''''''''') || ''''''''); end;';
end;
/
set verify on
set feedback on
set define on
prompt  ...done