topic Re: tOracleBulkExec - in Talend Studio

tOracleBulkExec -

Anonymous — Sat, 16 Nov 2024 03:50:39 GMT

I'm trying to use tOracleBulkExec as part of my design to load a huge flat file data
but I'm facing the below issue:
"Field in data file exceeds maximum length" for most of the fields.

In order to mitigate the default datatype in SQLLDR - char(255) issue, I modified my control file to use the required length for all the fields as below

"Col_A" CHAR(2000),
"Col_B" CHAR(255),
"Col_C" CHAR(255),
"Col_D" CHAR(25) etc.,

and checked the "Use existing control file" option to use the modified .ctl file. But, still ended up getting the same error.
Any suggestions to resolve this error?

I'm trying to use tOracleBulkExec as part of my design to load a huge flat file databut I'm facing the below issue:"Field in data file exceeds maximum length" for most of the fields.In order to mitigate the default datatype in SQLLDR - char(255) issue, I modified my control file to use the required length for all the fields as below "Col_A" CHAR(2000),"Col_B" CHAR(255),"Col_C" CHAR(255),"Col_D" CHAR(25) etc.,and checked the "Use existing control file" option to use the modified .ctl file. But, still ended up getting the same error.Any suggestions to resolve this error?

Re: tOracleBulkExec -

Anonymous — Fri, 13 Dec 2019 02:13:01 GMT

Hi,

Could you please share the table DDL and also the current schema you are suing to load the data? I would also prefer Varchar instead of Char to save the space in DB.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved