Articles Tagged: ORA-02291

When Insert Trigger is Disable: SQL> Insert into Employee(name,roll,department) values(‘Tom’,12123, ‘Business’); ERROR at line 1: ORA-02291: integrity constraint (FK_STUDENT_DEPARTMENT_NAME) violated – parent key not found No ORA-02067 error SQL> select sysdate from dual; SYSDATE ——————- 2013-12-20 13:00:47 In the trigger, we could catch the exception for ORA-02055 and rollback but the problem is a trigger […]