Re: [DBD::Oracle] ORA-02005 on array insert
"Peter J. Holzer" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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
| | | [email protected] | bleiben, mir und andern."
__/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd
signature.asc
(application/pgp-signature, 190 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iD8DBQFPab//MdFfQa64PCwRAlXAAJ9EXEwEgsWREFqcIjmfsrQYlwzQGwCgnJ3b LteiAQd/DTKWEqfBvQjJyP4= =ARVX -----END PGP SIGNATURE-----