Deleting elements from a nested table
8844Nov 7 2007 — edited Nov 9 2007Hi gang,
Looking for some geniuses (genii) to help me with the following problem:
I have declared a nested table as such:
TYPE nta IS TABLE OF VARCHAR2(1) INDEX BY PLS_INTEGER;
TYPE ntb IS TABLE OF nta INDEX BY VARCHAR2(20);
TYPE ntc IS TABLE OF ntb INDEX BY VARCHAR2(20);
In tests, I have successfully loaded values into this table (of tables) and can retrieve values by using the syntax v_value := ntc(idx1)(idx2)(idx3);
However, I have written the following line:
ntc.DELETE(idx1)(idx2)(idx3);
and the procedure fails to compile with the following error:
PLS-00801: internal error [22503]
Have I missed something or is this code flukey and shouldn't work in the first place?
Thanks in advance.
Leo