APEX_LANG

APEX_LANG.MESSAGE API is a great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc.

MESSAGE function is very useful to translate the messages or string returned from PL/SQL stored procedures, functions, triggers, packaged procedures, and functions.

Syntax

APEX_LANG.MESSAGE (
    p_name            IN VARCHAR2 DEFAULT NULL,
    p0                IN VARCHAR2 DEFAULT NULL,
    p1                IN VARCHAR2 DEFAULT NULL,
    p2                IN VARCHAR2 DEFAULT NULL,
    ...
    p9                IN VARCHAR2 DEFAULT NULL,
    p_lang            IN VARCHAR2 DEFAULT NULL,
    p_application_id  IN NUMBER   DEFAULT NULL)
RETURN VARCHAR2;

Examples:

• Define Message Shared Components > Globalization > Text Messages

How to use APEX_LANG.MESSAGE?

1. Plain String

Select apex_lang.message(p_name=>'TEXT_MESSAGE') from dual;

2. Specific language

Select apex_lang.message(p_name=>'TEXT_MESSAGE', p_lang=>'hi') from dual;

3. With Substitution

Select apex_lang.message('MESSAGE_WITH_SUBSTITUTION', V('APP_USER')) from dual;

4. Test in Command Prompt

Select apex_lang.message('MESSAGE_WITH_SUBSTITUTION','Ashish ', p_application_id =>128 ) from dual;

Here Application id is 128 where i have created the Messages.

Demo