gilta03

Tech Tip: Javelin: OracleBulkCopyActivity error- ORA-26093: input data column size exceeds the maximum input size

Discussion created by gilta03 Champion on Jan 4, 2018

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 

Outcomes