Originally posted by: SystemAdmin

Hi,

I'm sure this is simple but it seems very strange. I have two tables (one detail and one summary). I am aggregating the data from the first table and inserting it into the second table. The first table has 3 fields which are dates and the same 3 fields are on the second table. When I run the map, I receive the following error "OCI Date Conversion Error".

I had all kinds of problems with date formats when my source was SQL Server to Oracle but I did not expect this problem when going from Oracle to Oracle.

Does anyone know what this error means? Any help is greatly appreciated.

Thanks

Richard
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Did you tried takeing that date has u:70a2a43d69CHAR[/u:70a2a43d69], somtimes it work
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Hi,

I don't see any issues here provided the following
The date format in Instance1 (I1) and Instance2(I2) of Oracle are same.
You are not using any type of conversion while extracting the data.
You are using the same datatype in both the stages, sometimes its possible that you select DATE in one and TIMESTAMP in another.

If these things are in place I don't see any issue. Still if you want to load them yu can use the built in transform "DateYearFirstToOraOCI" transforms, this makes your input date in the year first format. For this you need to use a transformer stage.
Or
You can use the IConv and OConv functions appropriately to convert the dates. THIS IS THE ULTIMATE OPTION

If you are not using transformer, find out the date format in I1 and I2, then use
to_char(yourcolumn,'your format'), then load.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange