Print Thread
variables in debug
#59287 12/22/18 12:19 PM
Joined: Mar 2004
Posts: 166
V
vlevi Offline OP
Member
OP Offline
Member
V
Joined: Mar 2004
Posts: 166
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.

Re: variables in debug
vlevi #59288 12/24/18 09:50 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you right-click on the package, select "Add debug information", and try again?


Marco Kalter
Allround Automations
Re: variables in debug
Marco Kalter #59296 12/27/18 08:50 AM
Joined: Mar 2004
Posts: 166
V
vlevi Offline OP
Member
OP Offline
Member
V
Joined: Mar 2004
Posts: 166
I compiled this package many times, with debug information.
But I tried to add debug information manually, does not help frown
[url=https://drive.google.com/file/d/1TrzUO1KDYIPh-ONyUstBD_7p0UkwTsxI/view?usp=sharing][/url]


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

Re: variables in debug
vlevi #59299 12/27/18 10:13 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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\<User>\AppData\Roaming\PLSQL Developer 13).




Marco Kalter
Allround Automations
Re: variables in debug
Marco Kalter #59300 12/27/18 12:22 PM
Joined: Mar 2004
Posts: 166
V
vlevi Offline OP
Member
OP Offline
Member
V
Joined: Mar 2004
Posts: 166
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.


Re: variables in debug
vlevi #59301 12/27/18 01:12 PM
Joined: Mar 2004
Posts: 166
V
vlevi Offline OP
Member
OP Offline
Member
V
Joined: Mar 2004
Posts: 166
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.


Re: variables in debug
vlevi #59303 12/27/18 03:22 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Is the mn_elem variable from the screenshot a local variable in a function or procedure within the package?


Marco Kalter
Allround Automations
Re: variables in debug
Marco Kalter #59310 01/02/19 09:48 AM
Joined: Mar 2004
Posts: 166
V
vlevi Offline OP
Member
OP Offline
Member
V
Joined: Mar 2004
Posts: 166
Hello.
It is a local variable.

Re: variables in debug
vlevi #60033 05/16/19 07:45 AM
Joined: Mar 2004
Posts: 166
V
vlevi Offline OP
Member
OP Offline
Member
V
Joined: Mar 2004
Posts: 166
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.


Last edited by vlevi; 05/16/19 07:46 AM.
Re: variables in debug
vlevi #60036 05/16/19 09:12 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Unfortunately we have no additional findings. The variable is not reported as such by the Oracle Debugger.


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.030s Queries: 14 (0.007s) Memory: 2.5395 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-19 23:16:01 UTC
Valid HTML 5 and Valid CSS