PL/SQL Developer freezing when listing table columns

[gneto84]

Hello,

I'm currently using PL/SQL Developer Version 8.0.4.1514 and I'm facing this annoying issue when using table aliases.

Everytime I try to retrieve the columns from a given table by using "." after the table alias, pl/sql freezes.

As soon as I hit the "." after the alias, I get the messagem from Windows saying that PL/SQL is not responding anymore.

Have you seen this bug before? Is there a fix available?

Thanks, guys!

Cheers

 

[Marco Kalter]

Can you download the current 14.0 trial version and try again? It can be downloaded here:
https://www.allroundautomations.com/products/pl-sql-developer/free-trial

If it is still causing a freeze, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files (x86)\PLSQL Developer 14\plsqldev.exe" DebugSQL

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

 

[gneto84]

Hello, Marco.

Trial version 14.0 seems to be OK. Couldn't reproduce the freeze with this version so far.

I guess I'll just upgrade from version 8 to 14.

Thanks!

 

[gneto84]

In time: is there any workaround for this problem on version 8?

Thanks!

 

[Marco Kalter]

Version 8 uses a different method to resolve the object name. The only solution is to upgrade.

 

[gneto84]

Got it. Thanks for your attention, Marco.

Cheers!

 

[D.Wenzel]

Servus, is that not a candidate for the canames.sql
fixx with alternativ sql?

Yours Daniel