0

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

1

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.

6
  • Do go to far I'm trying this right now
    – Jason Krs
    Apr 12 '18 at 22:48
  • Here is the culprit SQL statement select ROLE GRPNAME ,FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc How to resolve the issue from here ? FRM50_ENABLED_ROLES is a view created on step 1 here. It's related to Oracle Forms 10g
    – Jason Krs
    Apr 12 '18 at 22:58
  • That SELECT statement executes properly where I execute it in SQL*PLUS
    – Jason Krs
    Apr 12 '18 at 23:03
  • 1
    @JasonKrs Then I would double-check the owner, name, type and existence of the objects related to that view/synonym. The view should exist in the SYSTEM schema. The synonym should be a public synonym, with the same name. Apr 12 '18 at 23:25
  • Awesome Balazs... Problem solved... Actually I created the view with sys as sysdba instead of simply using system.. So the owner of the object was not correct... Thank you Sir
    – Jason Krs
    Apr 13 '18 at 0:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.