B.10 Installing Translated Versions of Oracle Application Express

You must run load_lang.sql script to run a translated version of Oracle Application Express.

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 Application Express.

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).

Learn how to install a translated version of Oracle Application Express.

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 Application Express 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 following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_180200;
   

4. 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).