PLSQL debugger problem.

[thillson]

FYI,
We have plsql developer 5.1.0.654. I'm having a problem with the debugger. It appears that if I try to get the value of a nested table, the tool gets confused. A single level nested table is fine, but multi-level nested tables appear not to work too well for the variable value.

The example that causes me problems:
CREATE OR REPLACE TYPE Varchar4000Table IS TABLE OF VARCHAR2(4000); -- one level

CREATE OR REPLACE TYPE Varchar4000x2 IS TABLE OF varchar4000Table;

Then in the code in a test window:
filtersx2.EXTEND(1);
filtersx2(1) := varchar4000Table();
filtersx2(1).EXTEND(20);
filtersx2(1)(1) := '1';
filtersx2(1)(2) := 'Organization';
filtersx2(1)(3) := '52';

I try to mouse over filtersx2(1)(1) to see its value, the cursor changes to an hourglass and it never returns.

Any ideas?

Thanks,
Tom Hillson

 

[Marco Kalter]

Seems like a bug. We'll look into this.

------------------
Marco Kalter
Allround Automations

 

[thillson]

This problem also occurs if you mouse over the following type of statement:

IF filtersX2(idx).EXISTS(filIdx) THEN

It is still referencing the 2 dimensional table.

Thanks,
Tom