Print Thread
can't debug
#64115 08/04/22 01:38 PM
Joined: Aug 2022
Posts: 1
R
Member
OP Offline
Member
R
Joined: Aug 2022
Posts: 1
Good Morning.
We are having technical difficulties to run "DEBUG" in some large routines that we have, and we would like some help.

When opening a procedure in debug mode, adding a breakpoint in a certain line and clicking on start, the program is running for hours and does not reach the breakpoint and also does not finish the execution.

For tests, I executed the same procedure in another software "sqlDeveloper" and in just 4 minutes the execution reaches the breakpoint.

This problem only happens in very large procedures.

Could you please give us some guidance on how to proceed?

My version is 12.0.3.1821
Oracle 12g

Thanks.

Last edited by RaphaelCosta; 08/04/22 01:41 PM.
Re: can't debug
RaphaelCosta #64117 08/05/22 08:48 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 12).


Marco Kalter
Allround Automations

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.028s Queries: 14 (0.007s) Memory: 2.4955 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-28 15:31:13 UTC
Valid HTML 5 and Valid CSS