sukhadukkham
Member³
hi all,
i have problems with the test-window when placing the cursor over a two-dimensional array while debugging. doing this causes pldev to completely hang and the only solution is to use the task-manager to kill pldev and restart. please find a simple test for this below
i have problems with the test-window when placing the cursor over a two-dimensional array while debugging. doing this causes pldev to completely hang and the only solution is to use the task-manager to kill pldev and restart. please find a simple test for this below
Code:
CREATE OR REPLACE TYPE AR_NUM AS VARRAY(2147483647) OF NUMBER
/
CREATE OR REPLACE TYPE AR_AR_NUM AS VARRAY(2147483647) OF AR_NUM
/
CREATE OR REPLACE PROCEDURE DEBUG_TEST
AS
lar ar_num := ar_num();
lar_ar ar_ar_num := ar_ar_num();
ln_dummy PLS_INTEGER;
BEGIN
lar.EXTEND(10);
FOR
i IN 1..10
LOOP
lar(i) := i;
END LOOP;
lar_ar.EXTEND(10);
FOR
i IN 1..10
LOOP
lar_ar(i) := lar;
END LOOP;
FOR
i IN lar_ar.FIRST..lar_ar.LAST
LOOP
FOR
e IN lar_ar(i).FIRST..lar_ar(i).LAST
LOOP
--------------------------> PLACE CURSOR OVER ARRAY HERE
ln_dummy := lar_ar(i)(e);
END LOOP;
END LOOP;
END DEBUG_TEST;
/
ld values while debugging.
