Usage Note 539: Oracle prepare error: ORA-00904: invalid column name
When using SAS/Access Interface to Oracle with proc sql pass-through
statements, the following error may occur:
Oracle prepare error: ORA-00904: invalid column name
Make sure that the column names listed in the inner select statement
are in single quotes. If the column names are enclosed in double quotes this message will appear.
If using macro variables within single quotes, use the following syntax:
%unquote(%str(%'¯ovar%'))
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows 95/98 | 8 TS M0 | |
| Microsoft Windows NT Workstation | 8 TS M0 | |
*
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: | |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2008-01-03 14:50:33 |
| Date Created: | 1999-04-05 00:00:00 |
