Chris Underhill wrote:
I'm experiencing a similar problem to that reported last month by Jan Carlsson - see for example:http://www.nntp.perl.org/group/perl.dbi.users/2008/08/msg33156.html
[Snip]I'm also able to reproduce this on an old 32-bit i386 RHEL3 box, upgraded to perl 5.8.8 and DBI-1.607 with 9.2.0.6 Oracle client, and a 64-bit x86_64 RHEL4.6 box with perl 5.8.5 and DBI-1.605 with Oracle client 10.1.0.3. Also it errors with a 11.1.0.6 server.
In summary, my test case causes ORA-24347 errors connecting to 9.2.0.8, 10.2.0.2 and 11.1.0.6 database, using 9.2.0.6, 10.1.0.3 and 11.1.0.6 client, both 32-bit and 64-bit, with DBD-Oracle-1.22. DBD-Oracle 1.21 works fine however.
Interestingly I have another complex query (a function returning a sys_refcursor) that barfs with an ORA-24347 using DBD-Oracle 1.21 and client 11.1.0.6 or 10.1.0.3 (9.2.0.8 database). This however works with DBD-Oracle 1.20 on that box (64-bit x86_64 Centos 4.6).
Cheers, Chris.
signature.asc
Description: OpenPGP digital signature
