ORA-00904 After adding column in DB Link table

[Tom Foran]

I have a program accessing a table through a DB Link. I just added a column to the table in the DB Link schema.

I do a simple query in the main schema and the column is included in the result set. When I try to do a package compile, the new column is marked with ORA-00904 invalid identifier.

This happened a few weeks ago and it through me for a loop. The fix was to remove and add the column using Toad. I am trying to ween myself away from Toad, but this keeps pulling me back in.

 

[Marco Kalter]

That's odd. This all happens on the server of course, both adding the column and compiling the package. The tool you use shouldn't really matter.

If you open a new SQL Window after adding the column and execute a "select * from

", does the column appear? If not, does it help if you log off and on in PL/SQL Developer and retry?