CODEWITHSUNDEEP
oracle-databaseoracle11g
gustavodidomenico
gustavodidomenico

Reputation: 4681

Why Oracle is complaining about a looping chain of synonyms (ORA01775) in package compilation?

I really need to understand why the behavior below is happening.

First, I just create a synonym:

CREATE SYNONYM SYN_NAME FOR MY_TABE@MY_DBLINK;

Second, when I try to select the rows from the table, the following error appears:

ORA-00942: table or view does not exist

Great, the table really does not exist.

However when I try to compile a Package that is using the synonym above, the compilation error is:

ORA-01775: looping chain of synonyms

There are no synonyms with the same name, cycling synonyms or database link/synonym conflicts in the entire database. Of course that when I create the table in the target database link schema, the errors runaway.

Could some one explain me why the errors aren't the same?

Upvotes: 1

Views: 6395

Answers (1)

gustavodidomenico
gustavodidomenico

Reputation: 4681

After updating to the Oracle Database 12c version, the error changed back to:

ORA-00942: table or view does not exist

If someone is experiencing that kind of exception, the answer is that it could be the synonym target missing and don't a loop synonym.

I hope it helps someone.

Upvotes: 1

Related Questions