Databases Reference
In-Depth Information
Figure 5-1.
Language directories of the APEX zip file
Within each directory, a language loading script is identified by the language code (for example,
load de.sql
or
load ja.sql
).
To load the language, you must first set the
NLS LANG
environment variable at the OS level. Check the
documentation for the proper command for your operating system (in this example we are running on
Windows XP). Note that this setting is always the same for every language being loaded:
set NLS LANG=AMERICAN AMERICA.AL32UTF8
Then, run the appropriate
load lang.sql
script in sqlplus using
sqlplus / as sysdba
:
ALTER SESSION SET CURRENT SCHEMA = APEX 040000;
@load
lang
.sql
where
lang
is the specific language (for example,
load de.sql
for German or
load ja.sql
for Japanese).
You can remove a language by running the corresponding
unload
lang
.sql
script.
Once the language is loaded, the option to use this language in the APEX login page can be found at
the bottom of the login region, as shown in Figure 5-2.