Oracle Forms – How to Circumvent ORA-01775 Looping Chain of Synonyms

oracle

I think I have a database problem… Not necessarily with Oracle Forms (10g)…Let me explain …

I'm trying to implement this Oracle Forms Menu Security Configuration When I do it, it says that I get ORA – 01775 "Looping Chain of Synonyms"…. Since I have NO IDEA what synonym is creating the problem, I was wondering how you guyz can help me fix this issue…. Maybe there is a DBA script somewhere to solve this….

UPDATE

Oracle Database trace log says the culprit SQL is :

select ROLE GRPNAME ,FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc and FRM50_ENABLED_ROLES is created from step 1 here

That statement executes properly where I execute it in SQL*PLUS

Best Answer

Set the below event in the database:

alter system set events '1775 trace name errorstack level 1';

This will make all the ORA-01775 errors logged in the alert log plus a trace file, and that trace fail should contain the Current SQL statement, that caused the error.

Related Question