Insert select continue with error
i have some sql scripts which make 

    insert into secondtable (field, field1)
    select field, field2 from table;

I use oracle 9.x and sqldevelopper.

When i launch them, on some insert select i have foreign key error. And so the they didn't insert the set who work.

Is it possible to say to oracle to continue same when the error appear and if possible to display or log the error ?

Thanks you
Insert select continue with error
===

i have some sql scripts which make 

    insert into secondtable (field, field1)
    select field, field2 from table;

I use oracle 9.x and sqldevelopper.

When i launch them, on some insert select i have foreign key error. And so the they didn't insert the set who work.

Is it possible to say to oracle to continue same when the error appear and if possible to display or log the error ?

Thanks you