Re: Getting Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle

2014-01-27 Thread Tony Byorick
Thanks for the responses to my question. I have not found a root cause for the problem however, I have found a workaround by installing the 32 bit version of ActiveState Perl and using it rather than the 64 bit version. With 32 bit Perl, "$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid;p

prepare_cached() and forking

2014-01-27 Thread felix
I have a Perl daemon which gets this error once very couple of hours under stress testing -- 5 daemons, 20 clients, with the load factor wandering around between 10 and 20. This is Centos 6.2 and DBI 1.616. 'prepare_cached(select x1, x2, x3 from x where x.id = ?) statement handle DBI::st=

Re: Getting Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle

2014-01-27 Thread Bruce Johnson
On Jan 27, 2014, at 12:25 PM, Bruce Johnson wrote: > > On Jan 27, 2014, at 12:04 PM, Alexander Foken wrote: > >>> >>> I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader >>> is failing because it is trying to load a 32 bit version of the Oracle >>> driver? >> >> Yes

Re: Getting Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle

2014-01-27 Thread Bruce Johnson
On Jan 27, 2014, at 12:04 PM, Alexander Foken wrote: >> >> I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader is >> failing because it is trying to load a 32 bit version of the Oracle driver? > > Yes. The "bitness" of Perl and the database libraries must match, not only

Re: Getting Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle

2014-01-27 Thread Alexander Foken
On 26.01.2014 01:19, Tony Byorick wrote: I am trying to configure an Oracle connection from Perl running on a Windows 7 desktop to an Oracle 11g database running on Linux; however the database connection step is failing. The following line of perl code fails: use DBD::Oracle; Below is the

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-27 Thread hhferreira
Hi Guys, We have run a test with the latest DBI (1.631) and DBD (1.68) versions but the same error persists. Our perl version is Active Perl v5.12.1. However, we were able to generate a segmentation fault with a similar test case passing as input 5000 test items in the arrays. The core file info