Six Stars

Change Number format On ctl File (sql loader)

Hello,
I would like to know if there is a possibility to put another format in my ctl file when I use a tOracleBulkExec.
In fact, for example, I have this on my file :
- "IDCT" "TO_NUMBER(ltrim(rtrim(:IDCT)), '999999999999D999999999999', 'NLS_NUMERIC_CHARACTERS=''. ''')"
When I want to hava more than 12 integers on my number ('999999999999999999999999D999999999999').
I want to create a new ctl file at each execution, so I don't want to create one, change it manually and use every next time this file.
Thanks for any suggestion !
2 REPLIES

Re: Change Number format On ctl File (sql loader)

not 100%% sure, but the "Specify .ctl files INTO TABLE clause manually" checkbox in the Advanced Settings sub-tab might work.
Six Stars

Re: Change Number format On ctl File (sql loader)

Thanks for your reply !
I think if I use this checkbox I have to write and describe every fields of my table.