Error compiling any object in current schema: "Runtime error occurred: 904 (ORA-00904: "TYPE": in (4224176)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error compiling any object in current schema: "Runtime error occurred: 904 (ORA-00904: "TYPE": in
Description

The following error occurs when user compiles any object in current schema:

"Runtime error occurred: 904 (ORA-00904: "TYPE": invalid identifier)"
Cause

SQL Navigator does not include the SYS schema prefix to the background query of USER_ERRORS view. This view also happens to exist in current schema and it does not include the TYPE column. Therefore, SQL Nav is using USER_ERRROS view in the current schema instead of SYS schema.
Resolution

WORKAROUND:
Rename USER_ERRORS in current schema.

STATUS:
Waiting for fix to be released in a future version of SQL Navigator for Oracle.
Defect ID

CR 9196

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title