Error Building in Oracle 'Invalid Identifier' ORA-00904
Article ID: 102466
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/
use of a Oracle SQL reserved word as Column Name.
Windows , Oracle Database
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