develooper Front page | perl.dbi.users | Postings from March 2012

Re: [DBD::Oracle] ORA-02005 on array insert

Thread Previous | Thread Next
From:
Peter J. Holzer
Date:
March 21, 2012 04:48
Subject:
Re: [DBD::Oracle] ORA-02005 on array insert
Message ID:
20120321114815.GF5078@wsr.ac.at
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
| |   | hjp@wsr.ac.at      | bleiben, mir und andern."
__/   | http://www.hjp.at/ |    -- Wolfram Heinrich in desd


Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About