I have an issue with loading a field in a table using OracleBulkCopyActivity from a flat file. In Oracle, the field is NUMBER(22,0). In the file, the field is 16 in length. I'm loading the file using ReadCsvToDataTableActivity from the DataTable to an IdataReader. Then I'm trying to use the OracleBulkCopyActivity. This is the data I'm trying to push: 12345678910111213141516
This is the error I am receiving:
RREUR/ERROR GridTools.Javelin.Common.BusinessException: Error in row 'x' column 'xx' ORA-26093: input data column size (xx) exceeds the maximum input size (22).
On this site https://stackoverflow.com/questions/5164805/oracle-column-value-size-issue/14465332, I found that Oracle bulk copy cannot handle converting strings to decimal or long when the string length exceeds 11. What is the best solution to fix this?
To view the cause and resolution of this issue, please go here- https://support.ca.com/us/knowledge-base-articles.TEC1301803.html