One Star

problem with oracle bulk loader

Hi, I have a problem with tOracleBulkExec component. The job is very simple: just the component itself, with this configuration (see attached images for Basic, Advanced, Schema tab)
Attached:
- A 10 row sample file I want to load: 
- the .ctl file created by Talend
- The "log" file from the loader
- The "bad" file from the loader

The problem seems to be on the number format (Invalid Number on the COSUMO_STD field). I tried also to change the NLS Language component setting from "Default" to "AMERICAN", but it didn't change anything.
Thanks a lot,
Andrea



POST_BULK.zip_20141209-1742.zip
3 REPLIES
One Star

Re: problem with oracle bulk loader

Hi everybody,
any news? I'm in big trouble and I'm in a hurry, because it is a production enviroment and I need to load a big amount of data.
I'm not able to accomplish this task because of this issue.
Thank you everybody,
Andrea
One Star

Re: problem with oracle bulk loader

It was a number format problem, for what I understand numbers shouldn't have more than 12 decimals to be loaded with bulk loader. If I use a java round function to limit the decimals, the bulk load works with no errors.
One Star

Re: problem with oracle bulk loader

Hi
I have the same problem with bulk insert and to get round it I load data in string format.
The other problem that I have is the ROWS PER COMMIT : I specified 1000000 but I have only 3 rows per commit. Could somebody help me?
Thanks a lot.
Otmane.