Can you show more of a code snippet (your SQL statement, prepare(), bind(), and execute() calls)?
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Bart Kelsey [mailto:[EMAIL PROTECTED] Sent: Friday, August 05, 2005 1:39 PM To: [email protected] Subject: DBD-Oracle error when inserting a date I'm running DBD-Oracle 1.16 and Oracle 10g... I'm attempting to insert into a date field, and getting this error message: DBD::Oracle::st execute failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: error possibly near <*> indicator at char 115 in 'insert into abbrev (code, type, num, description, who_added, date_added) values (:p1, :p2, :p3, :p4, :p5, to_date(:<*>p6, 'MM/DD/YYYY'))') [for Statement "insert into abbrev (code, type, num, description, who_added, date_added) values (?, ?, ?, ?, ?, to_date(?, 'MM/DD/YYYY'))" with ParamValues: :p5="informix", :p3="1", :p6="11/03/2000", :p1="critical", :p4="Critical", :p2="SEVERITY"] at /home/bart/www/bin/insert_data.pl line 98. As far as I can tell, this isn't the usual problem of a mismatched date format and bind variable (since the bind variable :p6 is definitely in MM/DD/YYYY format). Does anyone know what might cause this? Thanks, Bart 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.
