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

2012-03-21 Thread Peter J. Holzer
On 2012-03-20 15:25:43 +0100, Peter J. Holzer wrote: > On 2012-03-20 13:19:14 +, 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:

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

2012-03-20 Thread Peter J. Holzer
On 2012-03-20 13:19:14 +, 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 no

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

2012-03-20 Thread Peter J. Holzer
On 2012-03-20 08:24:36 -0400, John Scoles wrote: > > Ran into that one, or nearly like it, a while back. Was not able to find a > OCI/DBD solution so I just modified my code like this > > $sth->execute_array({},\ @undefs, \@undefs, \@data_ids, \@set_ids, $ct_none); > > so I had an array for

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

2012-03-20 Thread Martin J. Evans
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)),

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

2012-03-20 Thread John Scoles
ime this week I will try to look into it. Cheers John > Date: Tue, 20 Mar 2012 13:12:56 +0100 > From: h...@wsr.ac.at > To: dbi-users@perl.org > Subject: [DBD::Oracle] ORA-02005 on array insert > > A few months ago we upgraded two of our servers from RHEL 4 to RHEL6. > U

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

2012-03-20 Thread Peter J. Holzer
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