none
oracleCommand - Capture failed records RRS feed

  • Question

  • Hi All

    I am trying to Bulk Import some data into the oracle database

    For this i am loading data into an array
    Creating an Oracle Paramater - OracleParameter oraParamCustomerid = new OracleParameter(":CUSTOMERID", OracleDbType.Int32);
    Assigning my array to the Oracle Parameter oraParamCustomerid.Value = dCustomerIds;
    add the Paramater to the OracleCommand.Parameters collection,

    I execute the data using OracleCommand.ExecuteNonQuery() and the data loads. In case of failures i catch the OracleException and the OracleErrorCollection in the exception.Errors has all the error messages.

    Along with the error message is it possible to obtain the insert record for which the this error was generated? This would be nice for logging purposes.
    • Moved by eryang Wednesday, October 7, 2009 6:01 AM (From:.NET Base Class Library)
    Friday, October 2, 2009 7:43 PM

Answers