SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

skip exception in insert query

944524Jul 14 2015 — edited Jul 17 2015

HI,

I would like to log the exception into my error table while performing insert statement and skip those records and perform further , i came across with using LOG ERRORS is it possible to define my own table structure or need to follow defined error table structure

err_table

date,id,error_text

error_ext will have oracle error

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2015

Added on Jul 14 2015

8 comments

1,901 views