Error Building in Oracle 'Invalid Identifier' ORA-00904

book

Article ID: 102466

calendar_today

Updated On:

Products

CA Plex

Issue/Introduction

When building with Storage = Java Oracle Server multiple tables cause the error: ODBC Error: [Oracle][ODBC][Ora]ORA-00904: : invalid identifier
The fields, types, and table structure looks correct and referenced tables was built successfully as well.
First, try to use Oracle Syntax Checker online https://www.eversql.com/sql-syntax-check-validator/ 

Cause

use of a Oracle SQL reserved word as Column Name.

Environment

Windows , Oracle Database

Resolution

use of a reserved word as a field name (COMMENT). Renaming that field allowed it to be built. See, https://docs.oracle.com/cd/A58617_01/server.804/a58234/vol2_wor.htm

Additional Information

https://docs.oracle.com/cd/A58617_01/server.804/a58234/vol2_wor.htm