PL/SQL (MOSC)

MOSC Banner

ORA-00904: "xxxxxxxxxxxx": invalid identifier (3: 0): Warning: compiled but with compilation errors

in PL/SQL (MOSC) 4 commentsAnswered

I am working on a huge View I inherited. I was tasked with adding new columns to tables and adding them to views. The view is almost 2000 lines, it has the create section, and a union query. The field that shows up in this error message exists in the view, the underlying table, and is correct in length, spelling, etc. However, every time I try to compile it, I get the message in the title. I've checked for missing commas, parentheses, etc. and everything is there. I don't know where else to

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center