Hi all,

I have problem with PL/SQL Developer. Break button is not working for me. Icon is active (red), but after executing some query and click on the button, nothing happened. Also query never stop and PL/SQL Developer crash after some time. All queries are working on coleague computer with same preferences and break button is working for him too. Any ideas what to do with this?

Can you go to Preferences > Oracle / Connection and check how the "Session Mode" option is set? If it is set to "Single Session", can you change it to "Dual Session" or "Multi Session", restart PL/SQL Developer, and try again?

I am having the same issue on PL/SQL Developer 14 w/ Oracle 19c (19.3) client connecting to a 12c database (12.2). I am able to kill the session from another window and then I get a TNS bad packet error. I am using multi-session mode.

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 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\<User>\AppData\Roaming\PLSQL Developer 14).

I have sent an email to your support address.

Thanks. In the log file I can see that the break is sent, and that there is no subsequent "ORA-01013: user requested cancel of current operation" exception, which one would expect. Not all operations allow a break though.

As a test, can you run the following script in a SQL Window or Test Window and try to break it?

This procedure will "sleep" for 60 seconds, and you should be able to break it instantaneously.

Let me know how this turns out.

It behaves the same as trying to kill a query and hangs. I am 22 minutes into it "running"; eventually the connection will time out and die.

Some other observations:

If I am in an SQL window and hit break, nothing happens and the query runs forever (or until the connection idles and dies). If I try to close the tab I get a prompt something is running and am offered a Terminate button. Clicking that button hangs the entire application.

If I am in a TEST window and hit break it behaves the same as the SQL window. If I try to close the tab I get the same prompt as the SQL window except it DOES actually terminate the PL/SQL block.

Hopefully this adds some insight.

Maybe this is an environment problem. Can you start PL/SQL Developer, connect to this database, go to Help > Support Info and send me the text from the "Info" tab page?

I sent you another email.