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;
/
