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

Reply via email to