Berger, Daniel
6/10/2005 2:08:00 PM
> -----Original Message-----
> From: Graham [mailto:gandalfmeister@gmail.com]
> Sent: Friday, June 10, 2005 5:55 AM
> To: ruby-talk ML
> 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
There are three Oracle drivers: oracle, OCI8 and Ruby9i. I use OCI8
myself. Try one of the others and see how it goes.
Regards,
Dan