It seems that BulkCopy does some sort of type conversion based on the declared types of the columns in the DataTable that it is given.

If you print the Column.DataType.ToString() for the columns that are causing issues, there is a good chance that you will see a type other than the one which the database is expecting.

You can create a new data table from the using old one but explicitly change Column.DataType of the troubling columns to be of the type that the database expects. 

public DataTable potentialFix(DataTable dt) {    
    DataTable newTable = new DataTable(dt.TableName);

    //define columns for the new table with type string (or whatever type you want)
    foreach (DataColumn dc in dt.Columns)
    {
        newTable.Columns.Add(new DataColumn(dc.ColumnName, typeof(String)));
    }

    newTable.BeginLoadData();
    DataTableReader dtReader = new DataTableReader(dt);
    newTable.Load(dtReader);
    newTable.EndLoadData();

    return newTable;
}


Oracle.DataAccess.Client.BulkCopy - trying to cast varchar2 as number when it shouldn't
I am new to JMS and WAS. I am grateful if someone provides any reference that helps me to create a web application in eclipse with JMS and WAS 7.0.

Also want to get answers for below questions..


How to inject ConnectionFactory or Destination object (created in WAS) into application using jndi?
How to install and run JMS web application on WAS server?

