OraFAQ Forum: Forms » Getting ORA-01775: looping chain of synonyms error

Home » Developer & Programmer » Forms » Getting ORA-01775: looping chain of synonyms error (Forms 6i, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting ORA-01775: looping chain of synonyms error [message #328852]

Mon, 23 June 2008 01:46

rjayakumar
Messages: 3
Registered: June 2008

Junior Member

Hi,

I have Oracle forms 6i in windows. The database is oracle 10gR2. when i am trying to run the forms, i am getting the error: ORA-01775: looping chain of synonyms error.

I checked in the database for any self-refering synonyms or in loop as was explained for the error desc. But, there are no such synonyms, they are refering to the tables only.

Can anyone guide me in finding the cause and solution for this.

Thanks in advance.

Regards,
Jayakumar R

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #328858 is a reply to message #328852]

Mon, 23 June 2008 02:08

cjack
Messages: 22
Registered: June 2008

Junior Member

Hi
If the synonyms scenario like this

a= sys.b
b= sys.c
c= sys.a

You can check from all_synonyms this system view.

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #328903 is a reply to message #328858]

Mon, 23 June 2008 05:09

rjayakumar
Messages: 3
Registered: June 2008

Junior Member

I have checked in all_synonyms, there is no such synonym one refering to another like this.

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #328906 is a reply to message #328858]

Mon, 23 June 2008 05:17

rjayakumar
Messages: 3
Registered: June 2008

Junior Member

Hi,

Can someone tell what will exactly happen as soon as the database login credentials are entered when opening a Oracle Forms application, before the form's code is executed?

Thanks.

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #337114 is a reply to message #328852]

Tue, 29 July 2008 23:53

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #354772 is a reply to message #337114]

Tue, 21 October 2008 03:26

dattavg
Messages: 1
Registered: May 2008

Junior Member

hi

i am also geeting ora-01775 :looping chain of synonyms error.
when i am trying to run the form.This is first error which is appearing,before pre-form trigger.
I ahve checked all synonyms and databas objects ,found no problem.
Is any body aware how to debug/resolve this issue
thanks in advance

Regards
Dattatraya G
dattavg@gmail.com

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #354780 is a reply to message #354772]

Tue, 21 October 2008 03:46

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This error may also comes when a synonym points to a no more existing object.

Regards
Michel

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #399286 is a reply to message #328852]

Tue, 21 April 2009 07:35

robajohnson
Messages: 9
Registered: February 2006
Location: Dallas Texas area

Junior Member

I have the exact same problem. Forms 6i in a new 10gR2 db.

I only have 8 synonyms so it has not been too tough to confirm that they all reference a table or view and not another synonym and I have confirmed with select statements that selecting from any of my synonyms will return rows so everything is valid.

I am sooo stumped! Sad

Report message to a moderator

Re: Getting ORA-01775: looping chain of synonyms error [message #399595 is a reply to message #399286]

Thu, 23 April 2009 02:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Is forms using the same userid as you have used for your testing in SQL*Plus?

david

Report message to a moderator

Previous Topic:	Client_get_file_name
Next Topic:	Three blocks form execution problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 22:54:32 CST 2025