DECLARE v_dept dept%rowtype; BEGIN v_dept.deptno := 10; v_dept.dname := 'ICT'; insert into dept(deptno,dname) VALUES (v_dept.deptno,v_dept.dname); EXCEPTION WHEN DUP_VAL_ON_INDEX then DBMS_OUTPUT.PUT_LINE('The department with deptno ' || v_dept.deptno || ' already exist'); END; /