Installing Translated Versions of APEX

Learn about installing translated versions of Oracle APEX.

See Also: Managing Application Globalization in Oracle APEX App Builder User’s Guide

About Installing Translated Versions of APEX

Whether you are installing for the first time or upgrading from a previous release, you must run the load_lang.sql script to run a translated version of Oracle APEX.

The APEX developer and admin interface is translated into the 9 standard languages: French, German, Italian, Japanese, Korean, Portuguese (Brazil), Simplified Chinese, Spanish, and Traditional Chinese. Developers can choose to run the APEX development environment in any of the installed languages by simply selecting the language from the Sign In page or home page.

The APEX runtime engine which is used by developers to create applications is available in the following languages: Arabic, Brazilian Portuguese, Croatian, Czech, Danish, Dutch, Finnish, French, French - Canada, German, Greek, Hebrew, Hungarian, Icelandic, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (Portugal) (pt), Romanian, Russian, Serbian - Cyrillic, Serbian - Latin, Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Thai, Traditional Chinese, Turkish, Ukrainian, and Vietnamese.

Tip: In fully managed Cloud databases such as Oracle Autonomous AI Database or Oracle APEX AI Application Generator (APEX Service), APEX is pre-installed and pre-configured with all languages from the above list. Separate installation of the supported languages is unnecessary.

To support additional languages not covered in the above list, developers must provide their own translations. For example, if you develop a Bulgarian application and want to include report messages, such as pagination, in Bulgarian, you must translate the strings used in messages displayed in reports.

See Also: Translating Messages Used Internally by APEX in Oracle APEX App Builder User’s Guide

Installing a Translated Version of APEX

Learn how to run the appropriate language specific script to install a translated version of Oracle APEX.

The installation scripts are located in subdirectories identified by a language code in the unzipped distribution apex/builder. For example, the German version is located in apex/builder/de and the Japanese version is located in apex/builder/ja. Within each directory, there is a language loading script identified by the language code (for example, load_de.sql or load_ja.sql).

Note: If you have applied a Patch Set and then install translations, you must re-execute the Patch Set to apply all fixes to the translations.

To install a translated version of APEX:

Set the NLS_LANG environment variable, making sure that the character set is AL32UTF8. For example:
- Bourne or Korn shell:
```
NLS_LANG=American_America.AL32UTF8
export NLS_LANG
```
- C shell:
```
setenv NLS_LANG American_America.AL32UTF8
```
- For Windows based systems:
```
set NLS_LANG=American_America.AL32UTF8
```
Navigate to the directory under apex/builder based on the language you need to install. For example for German, navigate to apex/builder/de. Start SQLcl and connect to the database where APEX is installed as SYS specifying the SYSDBA role. For example:
- On Windows:
```
<SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>
```
- On UNIX and Linux:
```
$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>
```
Execute the appropriate language specific script. For example:
```
@load_lang.sql
```
Where lang is the specific language (for example, load_de.sql for German or load_ja.sql for Japanese).