View the Exhibit and examine the code in the PL/SQL block.
The PL/SQL block generates an error on execution. What is the reason?
A.
The DELETE(n) method cannot be used with varrays.
B.
The DELETE(n) method cannot be used with nested tables.
C.
The NEXT method cannot be used with an associative array with VARCHAR2 key values.
D.
The NEXT method cannot be used with a nested table from which an element has been
deleted.
http://docs.oracle.com/database/121/LNPLS/collection_method.htm#LNPLS1076
Restriction on DELETE If collection is a varray, you cannot specify indexes with DELETE.
A
A.
DELETE Collection Method
DELETE is a procedure that deletes elements from a collection. This method has these forms:
– DELETE deletes all elements from a collection of any type.
– From an associative array or nested table (but not a varray):
DELETE(n) deletes the element whose index is n, if that element exists; otherwise, it does nothing.
DELETE(m,n) deletes all elements whose indexes are in the range m..n, if both m and n exist and m <= n; otherwise, it does nothing.
http://docs.oracle.com/database/121/LNPLS/composites.htm#LNPLS99961