Print Thread
No popup message on exception in Test Window
#64470 03/03/23 12:08 PM
Joined: Mar 2023
Posts: 3
C
Member
OP Offline
Member
C
Joined: Mar 2023
Posts: 3
Using the PL/SQL Developer "Test Window", I'm used to debugging and have been doing it for years. When an exception is raised, the tool normally provides me with a popup-message to report the error, and ti gives me an option to open the stack-trace screen, which is great.

However, the behaviour seems to have inexplicably changed over the past few days. It feels to me like it's a PL/SQL Dev config issue, but I'm not aware of having changed anything, and I haven't found any configs that would seem to control this anyway.

As a demonstration, see the attached 2 screen-shots. When I explicitly raise an exception in the Test Window, I get a popup-box:

`BEGIN
Raise_Application_Error(-20110, 'Something bad happened');
END;`

However, if I wrap that exception inside a PL/SQL package and call the top-level package, I no longer get a popup-box. Instead, the error message is relegated to the status-bar, and I get no option to open the stack trace.

What's happened? Is this something I changed? I'm pretty sure the Oracle DB hasn't changed any debug settings, because I can replicate the problem on multiple databases for multiple clients.

`BEGIN
Error_SYS.Record_General ('AuxInfo', 'ERR: Something bad happened!');
END;`

Attached Files
pic1.png (26.32 KB, 41 downloads)
pic2.png (25.92 KB, 41 downloads)
Re: No popup message on exception in Test Window
cbhsoftware #64476 03/06/23 04:38 AM
Joined: Feb 2003
Posts: 392
The Netherlands
Member
Offline
Member
Joined: Feb 2003
Posts: 392
The Netherlands
Check the DSA dialogs in the preferences. Remove the entry >ViewStackDump<.
Hope this helps.

Re: No popup message on exception in Test Window
cbhsoftware #64479 03/06/23 11:29 AM
Joined: Mar 2023
Posts: 3
C
Member
OP Offline
Member
C
Joined: Mar 2023
Posts: 3
I'm feeling a bit stupid here, but what are the DSA dialogs? I can't find any reference to "View Stack Dump" in the PL/SQL Developer Preferences dialog-box.

Re: No popup message on exception in Test Window
cbhsoftware #64480 03/06/23 02:33 PM
Joined: Jan 2006
Posts: 39
J
Member
Offline
Member
J
Joined: Jan 2006
Posts: 39
Configure -> Preferences -> Options (under User Interface in left pane) -> "DSA Dialogs..." button at bottom on right.

Re: No popup message on exception in Test Window
cbhsoftware #64482 03/07/23 08:42 AM
Joined: Mar 2023
Posts: 3
C
Member
OP Offline
Member
C
Joined: Mar 2023
Posts: 3
Good call!
How did I get through 20 years of using this tool without knowing this functionality!
Thank you!


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.039s Queries: 16 (0.013s) Memory: 2.5139 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-29 19:49:56 UTC
Valid HTML 5 and Valid CSS