1. Installation Guide
  2. Installing and Configuring Oracle APEX and Oracle REST Data Services
  3. Installing Translated Versions of Oracle APEX

6.9 Installing Translated Versions of Oracle APEX

Learn about installing translated versions of Oracle APEX.

See Also:

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

Parent topic: Installing and Configuring Oracle APEX and Oracle REST Data Services

6.9.1 About Installing Translated Versions of Oracle 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 Oracle 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 Oracle APEX development environment in any of the installed languages by simply selecting the language from the

The Oracle 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, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (Portugal) (pt), Romanian, Russian, Serbian - Cyrillic, Serbian - Latin, Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Thai, Traditional Chinese, and Turkish.

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 Oracle Application Express in Oracle APEX App Builder User’s Guide

Parent topic: Installing Translated Versions of Oracle APEX

6.9.2 Installing a Translated Version of Oracle 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 Oracle APEX:

  1. 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
  2. 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 SQL*Plus and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role. For example:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

    • On UNIX and Linux:

      $ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
  3. 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).

Parent topic: Installing Translated Versions of Oracle APEX