Use this procedure to seed the translation repository for the specified application and language. This procedure populates the translation repository with all of the new, updated and removed translatable strings from your 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.
Syntax
APEX_LANG.SEED_TRANSLATIONS ( p_application_id IN NUMBER, p_language IN VARCHAR2 )
Parameters
Table 16-6 SEED_TRANSLATIONS Parameters
| Parameter | Description |
|---|---|
|
|
The ID of the application for which you want to update the translation repository. 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 seeding process of the translation repository 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, seed the translation repository
apex_lang.seed_translations(
p_application_id => 63969,
p_language => 'ja' );
commit;
-- Print out the total number of potentially translatable strings
--
for c1 in (select count(*) thecount
from apex_application_trans_repos
where application_id = 63969) loop
dbms_output.put_line( 'Potentially translatable strings found: ' || c1.thecount );
end loop;
end;
/