Tuesday, August 26, 2014

Error PLS-00302: Component must be declared

Error PLS-00302: Component must be declared

select xx.maxno from dual

Where 'maxno' is the function in other schema 'XX'

and we are getting the error PLS-00302.

There are many reasons for this error :-

One can be 'maxno' exists in the current schema
or

SELECT * from all_objects where object_name like 'XX'


If yes this error will come ...so either you have to change the schema name or change the duplicate
object name in your current schema.Hope it will solve your problem...