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!

FORALL bulk insert ..strange behaviour

259178Oct 31 2006 — edited Oct 31 2006

Hi all..
I have the following problem..
I use a FORALL bulk Insert statement to insert a set of values using a collection that has only one row. The thing is I get a ' ORA-01400: cannot insert NULL into <schema>.<table>.<column>' error message, whereas the row has been inserted into the table!
Any ideas why this is happening?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2006

Added on Oct 31 2006

18 comments

802 views