Getting an ORA-00904: invalid column name when using the ER diagram in an ORA-00904: invalid column name database.
Toad generates the following select when adding tables to the ER diagram:
SELECT ALLOBJECTS.OWNER, ALLOBJECTS.OBJECT_NAME, COLUMN_NAME,
DATA_TYPE, CHAR_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE,
CHAR_USED, COLUMN_ID, ALLOBJECTS.OBJECT_TYPE
FROM SYS.ALL_OBJECTS ALLOBJECTS, SYS.ALL_TAB_COLUMNS ALLCOLUMNS
WHERE ALLOBJECTS.OWNER = ALLCOLUMNS.OWNER
AND ALLOBJECTS.OBJECT_NAME = ALLCOLUMNS.TABLE_NAME
AND
( (ALLOBJECTS.OWNER = :p0 AND ALLOBJECTS.OBJECT_NAME = :p1) OR (ALLOBJECTS.OWNER = :p2 AND ALLOBJECTS.OBJECT_NAME = :p3))
ORDER BY ALLOBJECTS.OWNER, ALLOBJECTS.OBJECT_NAME, COLUMN_ID
WORKAROUND:
None
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center