Print Thread
Page 2 of 3 1 2 3
Re: Break button is not working.
Kevin Seymour #61666 05/20/20 09:18 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I see that you are using a 64 bit Oracle19 client. We have one more problem report like this for this exact client configuration. Even though we have not been able to reproduce this issue, the customer was able to resolve this by using the 32 bit version of PL/SQL Developer and a 32 bit Oracle Client.

As a test, can you download the 32 bit version of PL/SQL Developer and check if this resolved the issue for you too?



Marco Kalter
Allround Automations
Re: Break button is not working.
Marco Kalter #61672 05/20/20 01:48 PM
Joined: May 2012
Posts: 32
K
Member
Offline
Member
K
Joined: May 2012
Posts: 32
I have the exact same behavior when using 32-bit versions of the same software.

Re: Break button is not working.
Kevin Seymour #61684 05/22/20 01:18 PM
Joined: May 2012
Posts: 32
K
Member
Offline
Member
K
Joined: May 2012
Posts: 32
Marco, any other suggestions? It's pretty impossible to not break queries.

Re: Break button is not working.
Kevin Seymour #61685 05/22/20 02:22 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
At the moment I can only suggest that you try a previous Oracle Client version. Can you try this with an Oracle12 Client?


Marco Kalter
Allround Automations
Re: Break button is not working.
Marco Kalter #61686 05/22/20 02:39 PM
Joined: May 2012
Posts: 32
K
Member
Offline
Member
K
Joined: May 2012
Posts: 32
It works correctly with the 12c client.

Re: Break button is not working.
Kevin Seymour #61687 05/23/20 08:21 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Okay. We'll continue to investigate.


Marco Kalter
Allround Automations
Re: Break button is not working.
Dragonba #62107 10/19/20 07:53 AM
Joined: Apr 2016
Posts: 55
M
Member
Offline
Member
M
Joined: Apr 2016
Posts: 55
Hey.
99% of times I try to break execution it is not working since we installed version 14.02.1969. Maybe something changed recently? Before it was +/- fine.

EDIT: Ok, 99% of times is a little bit too harsh, but the bottom line is - lately something has changed to worse with this. Idk, looked through latest update changelog, couldn't find anything related.

Last edited by Martins; 10/19/20 08:02 AM.
Re: Break button is not working.
Dragonba #62108 10/19/20 08:33 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
The break function has not changed recently.


Marco Kalter
Allround Automations
Re: Break button is not working.
Dragonba #62120 10/21/20 03:06 PM
Joined: Apr 2003
Posts: 517
Portland, OR, USA
M
Member
Offline
Member
M
Joined: Apr 2003
Posts: 517
Portland, OR, USA
If/when break does not work for me and I don't want to wait, I open another PL/SQL Developer. Then I use the sessions tool to kill the session.

Re: Break button is not working.
mike #62152 10/28/20 10:18 AM
Joined: Apr 2016
Posts: 55
M
Member
Offline
Member
M
Joined: Apr 2016
Posts: 55
Got another complaint from a co-worker that the cancel SQL is no working anymore.
We're using version 14.0.3.1981.
Killing sessions is not an option because there are databases where I don't have ALTER SYSTEM priviliges.
We can try closing the SQL window and PLSQL developer offers a button "Terminate". But when I press that, plsqldev becomes not responding and the only option is to kill it.

Page 2 of 3 1 2 3

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.089s Queries: 14 (0.040s) Memory: 2.5617 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-19 19:53:34 UTC
Valid HTML 5 and Valid CSS