21.7 Translating Data That Supports List of Values

You create a dynamic translation to translate dynamic pieces of data. For example, you might use a dynamic translation on a list of values based on a database query.

Dynamic translations differ from messages in that you query a specific string rather than a message name. You define dynamic translations on the Dynamic Translations page. You then use the APEX_LANG.LANG API to return the dynamic translation string identified by the p_primary_text_string parameter.

See Also:

APEX_LANG in Oracle APEX API Reference

21.7.1 Defining a Dynamic Translation

You define dynamic translations on the Dynamic Translations page. A dynamic translation consists of a translate-from language string, a language code, and a translate-to string.

To define a dynamic translation:

  1. Navigate to the Translate Application page:
    1. On the Workspace home page, click the App Builder icon.
    2. Select an application.
    3. Click Shared Components.
    4. Under Globalization, click Application Translations.

      The Translate page appears.

  2. Under Translation Utilities, select Dynamic Translations.
  3. On the Dynamic Translations page, click Create and specify the following:
    1. Language - Select a target language.
    2. Translate From Text - Enter the source text to be translated.
    3. Translate To Text - Enter the translated text.
  4. Click Create.