NODATAFOUND exception raised when subscript designates an element that was deleted - PL/SQL Exceptions

Q.  Which collection exception is raised when a subscript designates an element that was deleted, or a nonexistent element of an associative array?
- Published on 09 Jul 15

a. NO_DATA_FOUND
b. COLLECTION_IS_NULL
c. SUBSCRIPT_BEYOND_COUNT
d. SUBSCRIPT_OUTSIDE_LIMIT

ANSWER: NO_DATA_FOUND
 
The NO_DATA_FOUND exception is raised when the FETCH statement is not able to find the relevant data that we have asked for.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲