KBI 310114 ODBC Errors And Invalid Identifier When Using Oracle


8.0A-0804 or below. This KBI only applies to customers using Oracle 9i, 10g and 11g as a backend.


18 Aug 2008


After installing Argent Extended Technology using Oracle 9i, 10g or 11g as a backend, issues occurred when storing data into the Oracle database.

When investigating the Argent Alert Engine Log, the following error message was noted:

“ODBC Error: ORA-00904: “type”: invalid identifier

            (FILE: AACMain.cpp LINE: 481)”

Technical Background

The issue is due to a SELECT statement that uses quotes (“) around the column name. The column name in the query is in lower case, but the column name in the table is in upper case.

Oracle identifiers are not case sensitive, but when an identifier is enclosed with a quote (“), it becomes case sensitive.


This has been addressed in Argent Extended Technology 8.0A-0807.