Re^3: Perl Script failing after oracle 10G driver upgrade

[poj]

In the original post you had the error on this record

Last extract to date: 20130211035545

and now you have an error on this record

Last extract to date: 080108131644

so it looks like you have a mixture of 2 digit and 4 digit years in your input data. If this is the case then try the SQL with to_date(?,'rrrrmmddhh24miss') as the rrrr accepts both formats.

poj

[Anonymous Monk]

We tried with diffrent date format to resolve this isse,but its not help full.

Existing date format yyyymmddhh24miss:

Tried with diffrent date format rrmmddhh24miss(Similar like NLS setting)