Problem Note 20714: TIMESTAMP format does not work for all foreign languages
 |  |  |  |  |
The following error may be issued when inserting timestamp values into Oracle using SAS/ACCESS® Interface to Oracle.
ERROR: ORACLE execute error: ORA-01830: date format picture ends before converting entire input string.
The format used for fractions of a second 'SSXFF' does not work for all locales even though NLS_DATE_LANGUAGE="American" is set.
To work-around this Oracle bug, select the Hot Fix tab in this note to access the hot fix for this issue.
Customers will appreciate this fix ONLY when NLS_LANGUAGE is set to a foreign language other than English. With this hotfix, timestamp inserts will now work (without users having to change their locale to American for the whole session).
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#020714A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#020714| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Oracle |
| Date Modified: | 2008-03-07 14:34:10 |
| Date Created: | 2007-08-01 12:44:03 |