Home -> Usenet -> comp.databases.oracle -> Help ! PLS-00201 - undeclared identifier Error

Help ! PLS-00201 - undeclared identifier Error

From: <coolcat_at_citynet.net>
Date: 1996/03/05
Message-ID: <4hgjpn$680_at_news.citynet.net>#1/1 






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.

Received on Tue Mar 05 1996 - 00:00:00 CET












Original text of this message