PL/SQL Developer hangs on "Describe standard functions"

[Roeland]

Hi,

We have 1 customer who's still on Oracle 9.2.0.4.
When connected and writing a query in a SQL window that use a standard function, PL/SQL Dev freezes after the "(".

for example:

select nvl(

Unchecking the option in "Preferences"> "Code Assistant" > "Describe standard functions" solves the issue.

My questions:
1) Does anybody know the source of this issue, so we can resolve it?
Which query is causing this?

2) If it can't be resolved, is it then possible to link this setting to databases? So we can use this feature on all the other databases except for this one customer.

Thanks,

Roeland

Windows 7
Oracle Client 11.2
PL/SQL Developer 8.0.4.1514
Oracle Server (Customer) 9.2.0.4.0

 

[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).

 

[Roeland]

Problem reproduced en debug.txt send.

Roeland