search cancel

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


Article ID: 8617


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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, 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? 


CA Test Data Manager (TDM)- Javelin


To resolve this error, you need to make sure the source data type is decimal or long, instead of string. The error message is telling us that the max string length for such a conversion is 11. 
This is by design and expected behavior. The default type is System.String. You will need to specify column datatype. This is usually done by a DBA because this is an Oracle limitation. 

Here are instructions on how to change a column's data type: 
Here is more information about String and Long data types: 

As a workaround, you can create a second DataTable so that the field that the numbers are in now flag as integers. Then create a select to the destination table to see the data type. 
After that you will just need to move the data to the new DataTable object. 

Additional Information

If you experience any further issues, please open a support case by going to