When running the PL/SQL Code in debug mode and hovering the cursor over
lt_inc_totals (on line 17)
after it has been executed is causing Oracle to core dump.
The PL/SQL statement being executed by Toad:
CREATE OR REPLACE PACKAGE mjl_array IS
PROCEDURE p_entry;
END mjl_array;
CREATE OR REPLACE PACKAGE BODY mjl_array IS
TYPE r_inc_totals IS RECORD
(inrtyp VARCHAR2(5)
,inrref NUMBER(3));
SUBTYPE ty_vchar_idx IS VARCHAR2(20);
TYPE t_inc_totals_1 IS TABLE OF r_inc_totals INDEX BY ty_vchar_idx;
TYPE t_inc_totals IS TABLE OF t_inc_totals_1 INDEX BY ty_vchar_idx;
PROCEDURE p_entry IS
lv_idx1 ty_vchar_idx;
lv_idx2 ty_vchar_idx;
lt_inc_totals t_inc_totals;
BEGIN
lv_idx1 := 'A';
lv_idx2 := 'B';
lt_inc_totals(lv_idx1)(lv_idx2).inrref := 123;
lt_inc_totals(lv_idx1)(lv_idx2).inrtyp := 'RS ';
END p_entry;
END mjl_array;
WORKAROUND:
None
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
