Oracle OCI stage

[arshi]

Hi,

In my job I am using Oracle OCI stage.If I click view data its giving the message as "OCI DATE Conversion Failed".But the data is populated correctly into target oracle table.

If I remove the date data(lessthan '01-JAN-2001') in the source(flat file) then it not showing that message.Any one give the reason for this.

using DATASTAGE: 8.0.1 , DB : Oracle 10g

Regards,
Arshi

[DSguru2B]

Are you able to select the date from sql developer? What is the length of your date field, as defined in your table?

[gateleys]

Is it because your source flat file has the year specified in 2 digits and not 4 digits, and hence, oracle is confused about the century?

gateleys

[arshi]

Hi DSguru2B and gateleys,

Length of the date field is 11 in the table.One of the source file date data is 13-AUG-1996.

Regards,
Arshi

[Hemant_Kulkarni]

try using to_date() function.

[arshi]

Hi Hemant,

The problem here is at View Data of Oracle OCI stage.i.e, as I mentioned earlier the message given as "OCI DATE Conversion Failed" for particular dates lessthan '01-JAN-2001'.
All the Dates populated correctly into the target oracle table.

Regards,
Arshi

[chulett]

If that's true then I'd report it as a bug to your Support provider.