Use this procedure to publish the translated version of an application. This procedure creates an underlying, hidden replica of the primary application and merges the strings from the translation repository in this new application. Perform a seed and publish process each time you want to update the translated version of your application and synchronize it with the primary application.
This application is not visible in the App Builder. It can be published and exported, but not directly edited.
Note:
This procedure is available in Application Express release 4.2.3 and later.
Syntax
APEX_LANG.PUBLISH_APPLICATION ( p_application_id IN NUMBER, p_language IN VARCHAR2 )
Parameters
Table 21-5 PUBLISH_APPLICATION Parameters
| Parameter | Description |
|---|---|
|
|
The ID of the application for which you want to publish and create the translated version. This is the ID of the primary language application. |
|
|
The IANA language code for the existing translation mapping. Examples include en-us, fr-ca, ja, he. |
Example
The following example demonstrates the publish process for an Application Express application and language.
begin
--
-- If running from SQL*Plus, we need to set the environment
-- for the Application Express workspace associated with this schema. The
-- call to apex_util.set_security_group_id is not necessary if
-- you're running within the context of the App Builder
-- or an Application Express application.
--
for c1 in (select workspace_id
from apex_workspaces) loop
apex_util.set_security_group_id( c1.workspace_id );
exit;
end loop;
-- Now, publish the translated version of the application
apex_lang.publish_application(
p_application_id => 63969,
p_language => 'ja' );
commit;
end;
/
Parent topic: APEX_LANG