SQL & PL/SQL

hi

i am trying to create error log, but the results are not correct.

i am inserting emp records in emp2, i have check constraints salary greater than 5000 in emp2 table

SQL> insert into emp2 (id, name, sal) select id, name, sal from emp log errors into error_log_emp2;

i have created error_log_emp2 table by using dbms_errlog.create_error_log procedure.

but, in error_log_emp2 table only three records inserted instead of six records listed which violate check constraint, and no records inserted in emp2 which will not violate check constraint.

Please help with your suggestions on using error logging.....

SQL> select id, name, sal from emp where sal>4990;
ID NAME SAL
---- -------------------- -----
8 LAKSHMI 5000
9 HEMA 5000
10 CHANDRA 5000
11 KESHAVA 5000
12 GEETA 6000
101 JUNK 5000


SQL>select * from error_log_emp2;

"ORA-02290: check constraint (AMDB.CHECK_SAL) violated " I 8 LAKSHMI 5000
"ORA-02290: check constraint (AMDB.CHECK_SAL) violated" I 9 HEMA 5000
"ORA-02290: check constraint (AMDB.CHECK_SAL) violated" I 8 LAKSHMI 5000