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.

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).