Home / Database / Oracle Application Express Documentation, Release 18.2
Application Express Installation Guide
Contents
Oracle Application Express Documentation, Release 18.2
Page 44 of 76

A.10 Installing Translated Versions of Oracle Application Express

Learn about installing translated versions of Oracle Application Express.

A.10.1 About 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).

A.10.2 Installing a Translated Version of Oracle Application Express

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

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