On 2012-03-20 15:25:43 +0100, Peter J. Holzer wrote: > On 2012-03-20 13:19:14 +0000, Martin J. Evans wrote: > > On 20/03/12 12:12, Peter J. Holzer wrote: > > >Anyway, since the upgrade sometimes (not always) array inserts returned > > >the error > > > > > > DBD::Oracle::st execute_array failed: ORA-02005: implicit (-1) > > > length not valid for this bind or define datatype (DBD ERROR: > > > OCIBindByName) > > > > > >Here is a test script which semi-reliably (>= 50% of the time) produces > > >the error message: > [...] > > I've run this a couple of dozen times and it never has failed for me. > > I was using Linux Ubuntu 10.10, Perl 5.10.1 (with threads), > > DBD::Oracle (from subversion trunk) and Oracle Instant Client 11.2. > > Upgrading the client to 11.2 would have been one of the next things on > my list of things to try. Currently we use instant client 10.2.0.5 (the > database is also 10.2). I'll try that tomorrow. It's probably still > worth investigating if the problem exists only with a 10.2 client.
Just tried it with instant client 11.2.0.3.0. I can still reproduce the problem. So it doesn't seem a 10.2 vs. 11.2 issue. hp -- _ | Peter J. Holzer | Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd
signature.asc
Description: Digital signature