Usage Note 16850: "ERROR: ORACLE execute error: ORA-00904: : invalid identifier.." occurs when you write a SAS® data set to an Oracle table
If a SAS data set contains variable names that are Oracle reserved words, the following error is returned when you try to write that data set to an Oracle table:
ERROR: Error attempting to CREATE a DBMS table. ERROR: ORACLE execute error: ORA-00904: : invalid identifier..
To work around the problem, you must rename the variables, using names that are not Oracle reserved words. To find out the Oracle reserved words for the version of the database that you are accessing, go to the Oracle Help Center and search for "reserved words oracle."
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 | |
Microsoft Windows XP Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
*
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.
Type: | Usage Note |
Priority: | low |
Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2008-03-04 15:00:54 |
Date Created: | 2006-01-12 15:28:10 |