Debug - multidimensional collection

[fukmichal]

Hello,

plsql developer cant handle with multidimensional collection while i'm debuging code.

I open new test window and type :
DECLARE
TYPE typ_tab_number IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
TYPE typ_tab_tab_number IS TABLE OF typ_tab_number INDEX BY PLS_INTEGER;

vt_num typ_tab_tab_number;
BEGIN
vt_num(1)(1):= 2;

dbms_output.put_line(vt_num(1)(1));
END;

and Start debugger...
after assigning a value to the collection i view collection variable (right mouse button/ view collection variable) then plsql developer EXPLODES - timeout, that never ends ...

i check debug.txt
00:03:03.079 TOracleQuery Debugger.GetValueQuery Start Query.Execute
SQL = declare
i integer;
fr integer;
begin
i := 0;
loop
:result := sys.dbms_debug.get_value(variable_name => :variable_name,
frame# => :frame#,
scalar_value => :scalar_value,
format => :format);
if i = 0 then
fr := :result;
end if;
exit when result in (0, 1, 32)) or (i = 9);
i := i + 1;
:frame# := :frame# + 1;
end loop;
if :result 0 then
:result := fr;
end if;
end;
:RESULT = 3
:VARIABLE_NAME = vt_num(1)(1)
:FRAME# = 0
:SCALAR_VALUE = Null
:FORMAT = Null
00:03:05.633 TOracleQuery TestForm.TestQuery End
Result = ORA-03113: koniec pliku w kanale komunikacyjnym
Duration = 104,505
00:03:05.635 TSQLThread SQLThread loop end
00:03:05.636 TSQLThread SQLThread loop done
00:03:05.637 TSQLThread SQLThread transaction management done
00:03:05.638 FinalizeTargetSession starts
00:03:05.640 TOracleQuery $0576D860 Start Query.Execute
SQL = select 'x' from dual
00:03:05.659 TOracleQuery $0576D860 End
Result = ORA-03114: brak połączenia z ORACLE
Duration = 0,015
00:03:05.660 TOracleSession $03086B20 Start Session.LogOff
00:03:05.661 TOracleSession $03086B20 End
Duration = 0
00:03:05.661 FinalizeTargetSession ends
00:03:05.662 TSQLThread SQLThread Suspend

Can you handle this?

 

[Marco Kalter]

I have added this to the list of enhancement requests.