Dear Friends, while working on some data migration i came across a particular problem. it vl be very helpful if anyone could find a solution. i had created a procedure to import data from one table into another. the tables had got the same structure, but the data in the table which i am tryin to import data frm has duplications that is denying me frm pushing the data into th other table coz i hav created sme contraints that the other does't have. i am using a cursor to bring the data frm the table and by using a for loop i am inserting it into the other table. but if an duplicate entry comes the for loop is existed and exeception handler is fired. my requirement is to omit those data and still continue inserting without existing the for loop. is it possible?? is there any way i could override the exception??