On 2012-03-20 13:19:14 +0000, Martin J. Evans wrote: > On 20/03/12 12:12, Peter J. Holzer wrote: > >A few months ago we upgraded two of our servers from RHEL 4 to RHEL6. > >Unfortunately the upgrade involved the OS, the Perl version (5.8.8 -> > >5.10.1), the Oracle client version (still 10g, but now instant client) > >and DBD::Oracle (1.19 -> 1.30 (now 1.38)), and we didn't note the > >problem at once, so it's unclear which of the many changes is the > >culprit, but I suspect it's a bug in DBD::Oracle. > > > >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.
hp
--
_ | Peter J. Holzer | Auf jedem Computer sollte der Satz Ludwigs II
|_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich
| | | [email protected] | bleiben, mir und andern."
__/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd
signature.asc
Description: Digital signature
