While compiling a new stored procedure, I got the above error. For
every DML statement, it gives me an error for the <table_name>, saying
that it is an undeclared identifier.
I have select, insert, delete, update on the tables, the public
synonyms are fine ...
After getting this message, I re-compiled another 'working' stored
procedure I had created last week. Now that one gives the same error
message as well.
A small PL-SQL block executed from SQL*Plus and doing a SELECT from
one of the above tables gets executed without a problem.
Any ideas ?
TIA.
