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
- DBD-Oracle error when inserting a date Bart Kelsey
-