From: "Berger, Daniel" <Daniel.Berger@...>
Date: 2005-06-10T23:07:51+09:00
Subject: Re: DBI Oracle error

> -----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