Oracle Loader, problem with blanks

[Edric]

Hi,

got a problem with the Oracle stage, when i use Sql Loader.
I have some datas that can have one blank (ie: CD_TEST varchar (10) not nullable = ' ')
The problem is that the loader don't use delimiters by default, it's fix lenght, and with the ctl generated, blanks means NULL.

So when i load datas, some rows are dropped.

I know that there's a variable called APT_ORACLE_PRESERVE_BLANKS that can be defined in the administrator, but the big problem with that, is that "varchar" doesn't mean anything after that, because CD_TEST for exemple will have the value 10 blanks.
With this, i have all rows on the output, but of course it can't work....

Maybe there's another variable that i don't know that i could use...

btw i use Datastage 7.1...