The last choice (8773) used a nested table as follows:
DECLARE l_string VARCHAR2 (10); TYPE nt IS TABLE OF VARCHAR2 (10) NOT NULL; l_nt nt := nt (); BEGIN l_nt.EXTEND; l_nt (1) := l_string; END;When Oracle attempts to assign l_string to an element in l_nt, a VALUE_ERROR exception is raised. So far, so good.
But a player noticed something odd here. Marcus checked the documentation on EXTEND and found this:
)is the only form that you can use for a collection whose elements have the
Yet the call to EXTEND did not raise an exception. Either the documentation is wrong or there is a bug in EXTEND. If it's the latter, it's a bug that has gone unnoticed for many versions. I have logged a comment to the Oracle Documentation team about this.