PROCEDURE x_burner
IS
TYPE VARCHAR2_TABLE IS TABLE OF VARCHAR2(20)
INDEX BY PLS_INTEGER;
l_test_table VARCHAR2_TABLE;
BEGIN
l_test_table(-10) := 'test value';
DBMS_OUTPUT.PUT_LINE(l_test_table(-10));
NULL;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
NULL;
END x_burner;
You could imagine TABLE TYPE as a generic array .. actually not an array because it's not static; more of an arraylist I guess. And yeah, as you can see in the example, I can set a negative index.
when you try to access an index with no element, ORA-01403: no data found exception is thrown.
(TODO: expound on INDEX BY option)
No comments:
Post a Comment