ORA-01775: Looping chain of synonyms error
407031Aug 15 2005 — edited Aug 15 2005Hello All!
The following SQL gives me ORA-01775. Any idea why and how I can resolve the issue?
Thanks,
regards,
Andrei
DECLARE
tP5Only NUMBER := 0;
BEGIN
SELECT COUNT(*)
INTO tP5Only
FROM (
SELECT ID, FIELD1, FIELD2, FIELD3 FROM P5@MY_DB_LINK SC
WHERE (FIELD3 = 'S1' OR FIELD3 = 'S2') AND NOT EXISTS (SELECT 1 FROM MY_LOCAL_TABLE GM WHERE SC.FIELD1 = GM.FIELD1 AND SC.FIELD3 = GM.FIELD3 AND GM.FIELD2 = SC.FIELD2));
END;