Hi,
version 11.2.0.3
We have recently seen the following occur over the last week or so on the database.
2 random different procedures failed with ORA-00904 - invalid identifier stating pi.<column_name> invalid identifier.
Column not referred to in the actual procedures and the column exists and no aliasing of the table with pi in the procedures concerned.
The column exists in table which is being read but bot actually used in the select statement.
Quick google search mentioned case-sensitivity but no changes in the table or column or program for years and no privilege, database changes recently.
Anyone seen similar behaviour before?
Is this some possible corruption at database level?
How best to resolve?
Thanks