invalid length date

[fleurlisalu]

hello!,
I have an erreur when I want load a table in the data warehouse it's :
invalid length for DATE or NUMBER bind variable

I tried to load the table without date and it's ok but when I put a date it's not ok , my type date is timestamp in my DBMS(ORACLE 10g) it's timestamp too. I don't know how to make .
can you help me Please?

[phanee_k]

Use to StringToTimestamp function in the transfer to convert the data if the source datatype is defined as String.


Thanks

[us1aslam1us]

I would suggest you to check the format of the source column and the target, If the formats are not proper it will shout for invalid length. Also check for the null values in the source.