Posted By: ITTCT PLSQL Devleoper hangs up - 10/11/22 11:29 AM
Hi,

I have some problem with the new version of the developer.
When I run a select with many rows and I try to scroll down (still fetching rows) the developer freezes and I cannot stop the execution, also when the rows are fetched and I resize the window the same happens.

The other thing is when I highlight or copy/cut some text from sql/program window then it hangs up for a couple of seconds, after this everything works fine.

Developer version:
PLSQL Developer 15.0.2
WIN 10

Thanks for your help.

Best regards,
ITTCT
Posted By: Marco Kalter Re: PLSQL Devleoper hangs up - 10/12/22 08:52 AM
To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

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

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 15).
Posted By: MAOR Re: PLSQL Devleoper hangs up - 11/11/22 08:15 PM
This problem (or similar) also occurs on PLSQL developer 14.
One simple way to reproduce the similar problem (on plsql 14 or 15):
1 - Start executing a very slow query (that will take some minutes to start returning data);
2 - Previous than the results arrive, click on the panel where the query results should appear;
3 - Verify that PLSQL hang!

Thanks,
MAOR
Posted By: ITTCT Re: PLSQL Devleoper hangs up - 01/11/23 02:54 PM
Hi Marco,

Sorry for the late reply, here is the debug file.

Thanks for your help.
ITTCT

Attached File
Debug.txt  (4 downloads)
© Allround Automations forums