|
SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
2 --Define an index-by table type.
3 TYPE num_table IS TABLE OF NUMBER
4 INDEX BY BINARY_INTEGER;
5
6 nums num_table;
7 some_num NUMBER;
8 BEGIN
9 nums(10) := 11;
10
11 BEGIN
12 some_num := nums(11);
13 EXCEPTION
14 WHEN NO_DATA_FOUND THEN
15 DBMS_OUTPUT.PUT_LINE('Element 11 does not exist.');
16 END;
17
18 END;
19 /
Element 11 does not exist.
PL/SQL procedure successfully completed.
|