ORA-01756

  The following are the settings in my server and the experiment results in the oracle database.
 
1. Linux Server system language  setting
 
LANG="en_US.UTF-8"
SUPPORTED="zh_TW.Big5:zh:en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"
 
2. Oracle database edition
 
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

3. Oracle database character set setting

SQL> select * from nls_database_parameters;

PARAMETER                VALUE
------------------------------
NLS_LANGUAGE             AMERICAN

NLS_TERRITORY            AMERICA

NLS_CURRENCY              $

NLS_ISO_CURRENCY          AMERICA

NLS_NUMERIC_CHARACTERS    .,