Home » SQL & PL/SQL » SQL & PL/SQL » ora-01775 looping chain of synonyms in forms 6i (merged) (menu item enable disable)
ora-01775 looping chain of synonyms in forms 6i (merged) [message #689051] Fri, 01 September 2023 02:29 Go to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
Dear Sir

Due to the error problem I was having

FRM-10256: User is not authorized to run Form Builder Menu

Using SQL Developer, I ran the script FRM60SEC.sql

New run menu, but Oracle form gives me an error

ora-01775 looping chain of synonyms in forms 6i

Could you please guide me on how to enable and disable menu items
What is the procedure for assigning the role in the menu
Re: ora-01775 looping chain of synonyms in forms 6i (merged) [message #689053 is a reply to message #689051] Fri, 01 September 2023 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68595
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
ora-01775 looping chain of synonyms

There is no relation between this error and Forms.
This error means that you have a synonym that points to a synonym... that points to one synonym of the list.

Re: ora-01775 looping chain of synonyms in forms 6i (merged) [message #689056 is a reply to message #689051] Fri, 01 September 2023 14:34 Go to previous message
Alien
Messages: 289
Registered: June 1999
Senior Member
Hi,

first of all. 6i? That was developed by the dinosaurs. It's been out of support ever since they went extinct. Smile (Seriously, it has been out of support for more than 10 years. You should upgrade to a new version by any means possible).

Second, chances are that you used the wrong user for the script. Perhaps sys or another dba-user instead of system?

Turn on a 1775 event to see in the alert log what causes the error. Then troubleshoot from there.

Regards,

Alien
Previous Topic: Remove duplicates
Next Topic: Jaro-Winkler similarity for 9i
Goto Forum:
  


Current Time: Wed Feb 21 15:57:17 CST 2024