Problem while debugging

[Marius]

Hi,

While debugging a large package, I keep on getting the same problem. Up to a specific point in the package, I can see all the variables with the values when moving the mouse over it (and in the variable list). But once I move over it, I keep getting the results as =(not a variable). This is also for variables that I could see the values for previously. Any ideas?

Marius

 

[Marco Kalter]

Variables may exist in a specific scope only. For example within a specific function, or a specific block. This is the only (valid) reason why a variable could display a value at one point, and at another point. Could this be the case?

 

[pjotr]

I posted about this problem some time ago. It was never solved, though. Would be great if it could be figured out what causes it, since not being able to debug certain parts are a real pain. Where I get this error, I need debugging the most...

The previous post on this subject is here:
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=000088#000004

 

[Marius]

FYI - this was an e-mail between Marco and myself - enjoy

Hello Marius,

This is indeed useful, thanks for letting me know!

Apparently the Oracle Debug API has some (undocumented) limitations for the code size of a single program unit or PL/SQL block. We'll check it out.

Greetings,
Marco Kalter (marco.kalter@allroundautomations.com)
Allround Automations (http://www.allroundautomations.com)

--------------------------------------------------------------------------------
From: Marius Nysschen [mailto:MariusN@discovery.co.za]
Sent: Friday, April 16, 2004 10:37 AM
To: Allround Automations Support; marco.kalter@allroundautomations.com
Subject: RE: Debugging problems
Importance: High

Hi Marco,

I have managed to figure out what the problem was/is with large packages and how to get around it.

At first I thought it to be the size of the complete package, but that wasn't the problem. The problem seems to be the size of your package's BEGIN....END.

The BEGIN...END of the package was 1762 lines. This contained huge IF..END IF statements (the largest of which was around 800 lines of code) and I had about 6 of these statements. I then started moving the code in between the IF...END IF into internally declared procedures and reduced the size of the BEGIN...END to 166 lines of code. Problem resolved - debugging is now working right through without having any issue with "Not a variable".

Hope you find this useful.

Regards,

Marius