Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

by poj (Curate)
on Aug 15, 2013 at 12:15 UTC ( #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


Comment on Re^3: Perl Script failing after oracle 10G driver upgrade
Select or Download Code
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
Node Status?
node history
Node Type: note [id://1049571]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (4)
As of 2014-07-26 15:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (178 votes), past polls