When you try to load any data with a date format to Oracle in a non-English environment, an error similar to the following message one occurs:

When BULKLOAD=NO, the environment variable is set as NLS_DATE_LANGUAGE=AMERICAN. However, when BULKLOAD=YES, the environment variable is not set.

A workaround for this problem is to set the environment variable prior to invoking the SAS® System.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :

A fix for this issue for SAS/ACCESS Interface to Oracle 9.21_M2 is available at:

A fix for this issue for SAS/ACCESS Interface to Oracle 9.3 is available at: