This content has been marked as final. Show 2 replies
the default reject limit is 0, your code will error out when the first error occurs..
..... log errors into error_log_emp2 reject limit unlimited;
probably you are having 3 rows in error log table coz you ran the inser statements 3 times. Note taht, error logging (only the logging part) is autonomous and auto commiting.
Edited by: jeneesh on Nov 19, 2012 11:50 AM