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