This content has been marked as final. Show 1 reply
someone here posted the solution and it worked for us:
7.14 Existence of an Object in the Schema With the Same Name as the Target Schema in the Database
12776878: If an object exists in the schema with the same name as the target schema in the database, then an error is displayed.
Schema named A has an object called Q. Schema named Q exists and has an object called Z.
When you call SchemaQ.ObjectZ from Schema A, it looks within Schema A for Q.Z. Z is not found and displays the following error:
ORA-06550: ..: PLS-00302: component 'XYZ' must be declared
Workaround: Rename one of the Q objects to R or some letter other than Q.
check with this select:
FROM dba_users y
FROM dba_objects a