Re: Help ! PLS-00201 - undeclared identifier Error

On Mar 05, 1996 12:39:46 in article <Help ! PLS-00201 - undeclared identifier Error>, 'coolcat_at_citynet.net' wrote:    

>Hi
>
>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.
  This looks like a permissions problem that I get sometimes. If your DBA has dropped and re-created the tables, then he will have to re-grant permissions. Also, permissions have to be granted to your userid, not to a role, but it sounds like you already know that.  

Amy Received on Wed Mar 06 1996 - 00:00:00 CET