Insert with Array Binding fails to return the exceptions thrown in the after insert trigger
Hello all,
we have a table with an after-insert-trigger, where some bussiness rules are checked.
We try to insert into this table from .Net using the ODP.Net's feature 'array bind'.
Problem: If there are more rows violating the bussiness rules, the OracleException which is thrown contains only one OracleError, the mesasge is right(containing the exception issued by the trigger) but its ArrayBindIndex is wrongly = 0.
We were expecting more OracleErrors with the right ArrayBindIndex to identify the rows which failed.
Can anyone explain this behaviour? Is array binding error handling not supposed to work with user defined exceptions?
Thanks for any hint,
we have a table with an after-insert-trigger, where some bussiness rules are checked.
We try to insert into this table from .Net using the ODP.Net's feature 'array bind'.
Problem: If there are more rows violating the bussiness rules, the OracleException which is thrown contains only one OracleError, the mesasge is right(containing the exception issued by the trigger) but its ArrayBindIndex is wrongly = 0.
We were expecting more OracleErrors with the right ArrayBindIndex to identify the rows which failed.
Can anyone explain this behaviour? Is array binding error handling not supposed to work with user defined exceptions?
Thanks for any hint,
0