Index | Home | Forums
Oracle PL/SQL Example 5-9 NOT NULL Constraint on Collection Elements
Example 5-9 NOT NULL Constraint on Collection Elements
DECLARE TYPE EmpList IS TABLE OF employees.employee_id%TYPE NOT NULL;
v_employees EmpList := EmpList(100, 150, 160, 200);
BEGIN
v_employees(3) := NULL; -- assigning NULL raises an error
END;
/
This page was created by oracleabc.com on Feb 23,2008 00:09:02
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here