RE: Issue with SQL statement
From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 07/22/04
- Next message: Tim Bunce: "(Fwd) yes/no question"
- Previous message: Steven Lembark: "Fix for problems installing DBD::mysql-2.9004 with mysql-4.0.20"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 22 Jul 2004 12:54:07 -0600 To: "Moreno, Javier" <JavierMoreno@eaton.com>, <dbi-users@perl.org>
>From oerr:
01861, 00000, "literal does not match format string"
// *Cause: Literals in the input must be the same length as literals in
// the format string (with the exception of leading whitespace). If the
// "FX" modifier has been toggled on, the literal must match exactly,
// with no extra whitespace.
// *Action: Correct the format string to match the literal.
What is your NLS_DATE_FORMAT for the session trying to perform this insert?
-- Ron Reidy Sr. DBA Array BioPharma, Inc. -----Original Message----- From: Moreno, Javier [mailto:JavierMoreno@eaton.com] Sent: Thu 7/22/2004 12:46 PM To: dbi-users@perl.org Cc: Subject: Issue with SQL statement Hi, I am attempting an insert with dates and I am getting the following: /* INSERT into MASTER_Entry VALUES (?,?,?,?,?,?,?) with values E1138132263904 Javier Moreno has become the new Systems Engineer for AMS. 2004-07-22 00:00:00 H B 3018525 2004-04-19 00:00:00 [Oracle][ODBC][Ora]ORA-01861: literal does not match format string (SQL-HY000)(DBD: st_execute/SQLExecute err=-1) */ Of course the first error message is from my application which basically outputs the values I am trying to insert. What I did also was insert manually in the database and then retrieve from it to see if I could find out what was wrong with my date format. From that SELECT I found out apparently I needed the hour as well so I corrected my insert accordingly. I have checked all other fieds and they fall within the needed length. Could you please advise? Regards, Javier Moreno ---------------- <<ole0.bmp>> Systems Engineer - Transmissions "When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth" - Sherlock Holmes This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
- image/bmp attachment: ole0.bmp
- Next message: Tim Bunce: "(Fwd) yes/no question"
- Previous message: Steven Lembark: "Fix for problems installing DBD::mysql-2.9004 with mysql-4.0.20"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
