variables in debug

[vlevi]

Can you help me, what is wrong?
local variables does not show up in the debug popup (and they are not variables in the lower part of the debug window too), but other packages are working well.
Tried with PLD 12, and with the new 13. Similar results.
This procedure is in a package, but the variables is a local number variable.
https://photos.app.goo.gl/A3swkWq9iJDTDf9j7

I'm working with this package for days, and, until this, I was able to view debug variables.

 

[Marco Kalter]

Can you right-click on the package, select "Add debug information", and try again?

 

[vlevi]

I compiled this package many times, with debug information.
But I tried to add debug information manually, does not help
https://drive.google.com/file/d/1TrzUO1KDYIPh-ONyUstBD_7p0UkwTsxI/view?usp=sharing

Maybe, the size of the package? 6200 lines long?

 

[Marco Kalter]

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 13\plsqldev.exe" DebugSQL

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

 

[vlevi]

Hello,
I did a debug.txt
https://1drv.ms/u/s!AvgmO8OCn7_bgoEln08ap4gTINyubA

my test script starts at line 3579.
for example, at line 510571, 00:02:20.118 GetVariable starts: mr_szocalap.N_OSSZEG

the variable is a local variable, a record type result set of a cursor inside the procedure, not package body, or package.

 

[vlevi]

I created a new package, which has only one sub procedure, and I put this, non debugable procedure into the new package. It works fine, so, I think it must be something with that package, that I cannot figure out.

 

[Marco Kalter]

Is the mn_elem variable from the screenshot a local variable in a function or procedure within the package?

 

[vlevi]

Hello.
It is a local variable.

 

[vlevi]

Any update on this problem?
Maybe I will try to reduce the size of the package, and try it, but it won't be easy, because all the package sub procedures are in use somewhere.

 

[Marco Kalter]

Unfortunately we have no additional findings. The variable is not reported as such by the Oracle Debugger.