Print Thread
Debugging and breakpoints
#65636 04/16/24 08:33 AM
Joined: Mar 2024
Posts: 2
K
Member
OP Offline
Member
K
Joined: Mar 2024
Posts: 2
When i debug a script, Plyxon breaks execution very many times.
The result is that i have to click "Run to completion" maybe 50 times for some scripts.

My theory is that maybe it breaks execution as soon as a new package/method is invoked?

The database packages i debug are rather big and advanced

Re: Debugging and breakpoints
Kkristoffer #65638 04/16/24 08:39 AM
Joined: Aug 1999
Posts: 22,361
Member
Offline
Member
Joined: Aug 1999
Posts: 22,361
Can you provide an example?


Marco Kalter
Allround Automations
Re: Debugging and breakpoints
Kkristoffer #65639 04/16/24 09:28 AM
Joined: Mar 2024
Posts: 2
K
Member
OP Offline
Member
K
Joined: Mar 2024
Posts: 2
I tried to create some test-packages to see if my theory held up. It didnt.
So i figured out what it was breaking on in my production code instead and managed to replicate that.

In this example the debugger breaks when a cursor calls a function.
I attached the example package and test-script.

1. Create the package and add debug information.
2. Open the test-script and click "Debug current command (F9)" button.
3. Click "Run to completion" button.
4. Notice that the bugger stops on line 32 (see example screenshot)

ps. not sure why, but when i created the package and tried to debug it in the same instance of Plyxon, it failed to hit breakpoints no matter how i tried.
After restarting Plyxon breakpoints started to be hit. Not sure if this affects the attached example; but if you can't recreate the issue try restarting Plyxon

ps2. My oracle version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0

Attached Files
TestPackage.txt (812 Bytes, 0 downloads)
SHA1: a1e2fe2b7d32cb6c69b1ab173af98bb3d5f07f3f
TestScript.txt (48 Bytes, 0 downloads)
SHA1: 4c572caf618ad81da6f42d2b6a1b9a62ba0752b3
Plyxon breaks here.png (57.95 KB, 32 downloads)
Re: Debugging and breakpoints
Kkristoffer #65644 04/17/24 08:54 AM
Joined: Aug 1999
Posts: 22,361
Member
Offline
Member
Joined: Aug 1999
Posts: 22,361
Thanks, we'll investigate!


Marco Kalter
Allround Automations

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.038s Queries: 15 (0.012s) Memory: 2.5082 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-10-14 10:29:09 UTC
Valid HTML 5 and Valid CSS