23.12 UPDATE_TRANSLATED_STRING Procedure
Use this procedure to update a translated string in the seeded translation repository.
Note:
This procedure is available in Application Express release 4.2.3 and later.
Syntax
APEX_LANG.UPDATE_TRANSLATED_STRING (
p_id IN NUMBER,
p_language IN VARCHAR2
p_string IN VARCHAR2 )
Parameters
Table 23-11 UPDATE_TRANSLATED_STRING Parameters
Parameter | Description |
---|---|
|
The ID of the string in the translation repository. |
|
The IANA language code for the existing translation mapping. Examples include en-us, fr-ca, ja, he. The language of the mapping cannot be updated with this procedure, only the new translation application ID. |
|
The new value for the string in the translation repository. |
Example
The following example demonstrates an update of an existing string in the translation repository.
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;
-- Locate all strings in the repository for the specified application
-- which are 'Search' and change to 'Find'
for c1 in (select id
from apex_application_trans_repos
where application_id = 63969
and dbms_lob.compare(from_string, to_nclob('Search')) = 0
and language_code = 'ja') loop
apex_lang.update_translated_string(
p_id => c1.id,
p_language => 'ja',
p_string => 'Find');
commit;
exit;
end loop;
end;
/
Parent topic: APEX_LANG