Popup Menu causes ORA-01437/ORA-06512

[TenGor]

Hy,

in my PL/SQL Dev. the Popup Menu causes the following errors:
ORA-01437 No Join with CONNECT by possible
ORA-06512 on Line 84

This happens if i right-click on a variable or on a function to test it.

I'm on
- PL/SQL Dev. 6.0.6.947
- Oracle 10g Release 2 Beta 3

Against my other DBs (8i, 9i) there is no problem.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug & debugsql parameters? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[TenGor]

File was sent.

 

[TenGor]

Hy Marco,

The select indeed fails with ORA-01437.
But the problem had been solved anyway.

A collegue of mine had set the DB-Parameter "_old_connect_by_enabled" to "TRUE" to test
a Hierarchical query and had forgotten to "reset" it to "FALSE".

To check it:
select value from v$parameter where name = '_old_connect_by_enabled';

To set it:
alter system set "_old_connect_by_enabled" = FALSE;

After this is done, anything is alright.

 

[Marco Kalter]

Great, thanks for sharing this information.