Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deleting elements from a nested table

8844Nov 7 2007 — edited Nov 9 2007
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2007
Added on Nov 7 2007
7 comments
712 views