Oracle Apex | get text message into sql and javaScript when implement translation

Translate text message

When you want to translate text into plsql code:

 

Then you have to define text with key in different language in shared components > translate > Text Message

 

And retrieve message through

APEX_LANG.MESSAGE('MSG_AVAILABLE');

 

 

When want to translated text into javaScript code:

 

Then you have to define text like below in different language in shared components > translate > Text Message

NOTE:= set "Used in javaScript" to "Yes"

 

Then you can retrieve message through following code:

apex.lang.getMessage('MSG_ERROR_CASE_SEARCH');