Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

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

by poj (Abbot)
on Aug 15, 2013 at 12:15 UTC ( [id://1049571]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Perl Script failing after oracle 10G driver upgrade
in thread Perl Script failing after oracle 10G driver upgrade

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

Replies are listed 'Best First'.
Re^4: Perl Script failing after oracle 10G driver upgrade
by Anonymous Monk on Aug 15, 2013 at 12:40 UTC

    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)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1049571]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2024-03-29 11:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found