From: Graham <gandalfmeister@...>
Date: 2005-06-10T20:55:28+09:00
Subject: Re: DBI Oracle error

My first attempt at debugging adopts your idea, so for the
parameterised insert of:
sth = dbh.prepare("INSERT INTO EFFLUENT_LOG (datetime, suspect, flow,
temp, ph) VALUES(to_date(?, 'DD/MM/YY HH24:MI:SS'), ?, ?, ?, ?)");

I now run on a row by row basis:-
sth.execute((date + " " + time), val, sprintf("%3.1f",flow.to_f).to_f,
sprintf("%4.2f", temp.to_f).to_f, sprintf("%5.2f",ph.to_f).to_f)
 whic smacks of paranoia in my book. However still get exactly the same
failures. (BTW The suspect field is a single character 'Y' or 'N' )

I'm beginning to think DBI for Oracle is extremely buggy.

Any suggestions for an alternative interface to Oracle, or ideas what
the problem might be?
Regards
Graham