CREATE TABLE employees AS SELECT * FROM hr.employees
Table created.
DECLARE
TYPE employee_aat IS TABLE OF employees.employee_id%TYPE
INDEX BY PLS_INTEGER;
l_employees employee_aat;
BEGIN
l_employees (1) := 137;
l_employees (100) := 126;
l_employees (500) := 147;
DBMS_OUTPUT.PUT_LINE (l_employees(99));
END;
ORA-01403: no data found ORA-06512: at line 11 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-00100
DECLARE
TYPE employee_aat IS TABLE OF employees.employee_id%TYPE
INDEX BY PLS_INTEGER;
l_employees employee_aat;
BEGIN
l_employees (1) := 137;
l_employees (100) := 126;
l_employees (500) := 147;
FORALL l_index IN l_employees.first .. l_employees.last
UPDATE employees
SET salary = 10000
WHERE employee_id = l_employees (l_index);
END;
ORA-22160: element at index [2] does not exist ORA-06512: at line 11 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-22160