Skip to Main Content
  • Questions
  • more specific error message with bulk insert save exception

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Ruchir.

Asked: May 16, 2017 - 10:11 pm UTC

Last updated: May 24, 2017 - 2:17 am UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

When I do a Bulk insert with save exceptions, I get a generic error message like
ORA-01400: cannot insert NULL into ()
Is there a way to capture the specific exception (like include column name which we get on a regular insert)

and Connor said...

Unfortunately no.

It seems you have to choose between

a) no 'save exceptions' and get the full error message,
b) 'save exceptions' and get the generic message associated with that error code.



Is this answer out of date? If it is, please let us know via a Comment