PL/SQL Developer Freezes in Single Session Mode

[Barry]

When developing in single session mode, a long running query will freeze PL/SQL Developer. I am unable to stop the query or do anything else. Works fine in Dual or Multi session.

 

[Marco Kalter]

In Single Session mode you should be able to press Shift-Esc (or whatever key you have assigned to Session > Break) to cancel a long-running query.

 

[Barry]

These are differences between single-session breaks and multi session breaks:

Single session:
select * from big_table
Shift-Esc works
select count(*) from big_table
Shift-Esc does not work (and screen is frozen)

Multi session:
select * from big_table
Shift-Esc works
select count(*) from big_table
Shift-Esc works

I am on Version 6.0.1.848 (MBCS)

 

[Marco Kalter]

Strange. I can't reproduce it though. Is this 100% reproducible for you?

 

[Barry]

Yes - this happens every time. Note that I am on Oracle 8.1.7

I notice that the single session behavior is the same as with SQL*Plus

Other versions of interest:
Windows 2000 version 5.0 (build 2195) Service Pack 3
Session mode: Single
OCI Library:
Use OCI7: False
Using
Home: 817_HOME
DLL: C:\APPS\ora_817\bin\oci.dll
OCI: Version 8.1
Oracle8i Enterprise Edition Release 8.1.7.4.0
Character size: 1 byte(s)

 

[Marco Kalter]

Can you upgrade to 6.0.4 and try again?