Usage Note 45383: Errors occur when you use SAS/ACCESS® Interface to ODBC to delete records from an Oracle database table
When you use SAS/ACCESS Interface to ODBC to delete records from an Oracle database table, errors similar to the following might occur:
ERROR: CLI cursor extended fetch error: [Oracle][ODBC][Ora]ORA-01410: invalid ROWID
This problem is caused by a bug in the Oracle ODBC driver. The bug, first discovered with driver release 11.02.00.01, affects only databases that use the UTF8 or AL32UTF8 character set. The Oracle bug ID for this issue is 10422748, and at this time the patch ID containing a fix for this is 13247523.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | |
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |
| Microsoft Windows XP Professional | 9.2 TS1M0 | |
| Windows Vista | 9.2 TS1M0 | |
| Windows Vista for x64 | 9.2 TS1M0 | |
| 64-bit Enabled AIX | 9.2 TS1M0 | |
| 64-bit Enabled HP-UX | 9.2 TS1M0 | |
| 64-bit Enabled Solaris | 9.2 TS1M0 | |
| HP-UX IPF | 9.2 TS1M0 | |
| Linux | 9.2 TS1M0 | |
| Linux for x64 | 9.2 TS1M0 | |
| Solaris for x64 | 9.2 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
ERROR: CLI cursor extended fetch error: [Oracle][ODBC][Ora]ORA-01410: invalid ROWID
| Date Modified: | 2012-01-23 22:51:25 |
| Date Created: | 2012-01-13 09:42:46 |
