Hello everyone. I’m having trouble translating alert messages in Oracle apex. Since my language (Bosnian) is not supported by apex, I’m trying to translate entire application manually. I’ve done 90% of work already, translating strings in Shared Components/Globalization/Text messages. I have found text message names and English text values on official oracle website on this link. Now my problem is to translate alert messages. For example when someone downloads a report, success messages is shown in English. Or when I try to add entry in table, if there is some problem,warning is shown in English. Does anyone know where to find those strings, or how to translate them? I’ll be really grateful.
Thanks in advance.
First of all, you have to replace the default messages to the custom messages. And to do this you have to create and specify the hidden page items in the SUCCESS and Error message areas. You can follow these steps:
You can create a table to store your messages in the Bosnian language. For example:
Insert the data into the above table as follows:
Now to show the messages using the alert, you can use Oracle Apex shortcuts in shared components, or you can assign the message on page load to a hidden item.
For example, create a hidden item (P2_SUCCESS_MSG) on the page you are downloading the file and set the default value as the following SQL query:
Now on page load, the item P2_SUCCESS_MSG will be populated with the message. You can then show it using the alert as follows:
Please let me know if any questions.
Hi Aleksandar!
You can create custom alert/success messages in plsql process.
I assume you have LANGUAGE application item which contain value of current language, then you can use this value in process for alert/success messages.
IF :LANGUAGE = ‘English’ THEN
apex_application.g_print_success_message := ‘<span style=”color: white”>Message</span>’;
ELSE
apex_application.g_print_success_message := ‘<span style=”color: white”>Poruka</span>’;
END IF;
You can change CSS of success message for alerts.
Pozdrav!