Issue while querying/trying to get get metadata

[Joby M]

Hi,

I am using PL/SQL Developer Version 7.1.1.1339
for accessing Oracle Database 11g Enterprise Edition Release 11.1.0.7.0.

While trying to type in a query with synonym name
(Eg :- typing in select * from my_synonym)
OR Right clicking mouse on an object's synonym
(Eg :- Right click on package's synonym name for viewing source)

I am getting the below error in a message window

ORA-01436: CONNECT by loop in user data
ORA-06512: at line 59

It is a bit annoying, while this comes multiple times out while working on some code.
Does somebody have a solution for this ?

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).