null value to timestamp

Edwink · Post by **Edwink** » Wed May 30, 2007 9:38 am

Friends,
when i tried to default the timestamp filed with null value("") in in transformation i am getting the folllowing error
APT_CombinedOperatorController,2: Conversion error calling conversion routine timestamp_from_ustring data may have been lost
Ora_Lot_Attributes,0: Failure during execution of operator logic.

but if i populate some timestamp field its running fine..

my requirement is i have pass(default) null value to the target field..
target datatype timestamp 38

Thanks

DSguru2B · Post by **DSguru2B** » Wed May 30, 2007 10:45 am

What function(s) are you using to change string to timestamp and for null handling?

Edwink · Post by **Edwink** » Wed May 30, 2007 11:41 am

i am not using any function convet string to time stamp m just hard coding as ""

DSguru2B · Post by **DSguru2B** » Wed May 30, 2007 11:52 am

"" is not a NULL and certainly not a valid timestamp and hance your error. Use SetNull() in transformer or make_null() in modify stage.

deepa_bhagia · Post by **deepa_bhagia** » Fri Jun 01, 2007 4:03 am

hardcode the column in the transformer before the target to SetNull()

ramoos99 · Post by **ramoos99** » Fri Jun 01, 2007 10:09 am

DSguru2B wrote:"" is not a NULL and certainly not a valid timestamp and hance your error. Use SetNull() in transformer or make_null() in modify stage.

I Hope there is no make_null() in Modify stage

ray.wurlod · Post by **ray.wurlod** » Fri Jun 01, 2007 2:52 pm

Why do you hope that?

There IS a make_null() function for the Modify stage. Unfortunately the Parallel Job Developer's Guide documents this incorrectly. You also need to read the Orchestrate Operators manual.