Use this procedure to delete the language mapping for the translation of an application. This procedure deletes all translated strings in the translation repository for the specified language and mapping. Translated applications are published as new applications, but are not directly editable in the App Builder.
This procedure is available in Application Express release 4.2.3 and later.
APEX_LANG.DELETE_LANGUAGE_MAPPING ( p_application_id IN NUMBER, p_language IN VARCHAR2 )
Table 22-2 DELETE_LANGUAGE_MAPPING Parameters
The ID of the application for which you want to delete the language mapping. This is the ID of the primary language application.
The IANA language code for the existing mapping. Examples include en-us, fr-ca, ja, he.
The following example demonstrates the deletion of the language mapping for an existing Application Express application and existing translation mapping.
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, delete the language mapping apex_lang.delete_language_mapping( p_application_id => 63969, p_language => 'ja' ); commit; -- -- Print what we just updated to confirm -- for c1 in (select count(*) thecount from apex_application_trans_map where primary_application_id = 63969) loop dbms_output.put_line( 'Translation mappings found: ' || c1.thecount ); end loop; end; /