Re: DBD::Oracle forked client hangs with Oracle Client Libraries 19.20 and later.

0, imp_dbh=imp_dbh@entry=0x55c5ef035390) at /root/.local/share/.cpan/build/DBD-Oracle-1.83-2/dbdimp.c:1263 #7  0x7f0c48a10752 in XS_DBD__Oracle__db_DESTROY (my_perl=0x55c5eee272a0, cv=) at ./Oracle.xsi:432 #8  0x7f0c48a4d106 in XS_DBI_dispatch (my_perl=0x55c5eee272a0, cv=0x55c5ef13b9c8

DBD::Oracle forked client hangs with Oracle Client Libraries 19.20 and later.

lib/oracle/21/client64/lib/libclntsh.so.21.1 #5  0x7f0c39e9a42e in kpufhndl0 () from /usr/lib/oracle/21/client64/lib/libclntsh.so.21.1 #6  0x7f0c48a1028a in ora_db_destroy (dbh=dbh@entry=0x55c5ef32c5b0, imp_dbh=imp_dbh@entry=0x55c5ef035390) at /root/.local/share/.cpan/build/DBD-Oracle-1.83-

Re: please help with DBD-Oracle-1.76

Also the SDK package needs to be installed or the build fails. Minimum for DBD::Oracle are the Basic and SDK packages. On Sep 5, 2022, at 6:43 AM, kmo...@esntech.com<mailto:kmo...@esntech.com> wrote: Hi Daniel, I have three questions. 1. Did you install the instant client as r

RE: please help with DBD-Oracle-1.76

download and install it to satisfy what is in your post Regards, Kevin From: Tim Bunce Sent: Monday, September 5, 2022 3:16 AM To: dbi-users@perl.org Subject: Fwd: please help with DBD-Oracle-1.76 Begin forwarded message: From: Daniel Chmielewski mailto:daniel.chmielew

Fwd: please help with DBD-Oracle-1.76

> Begin forwarded message: > > From: Daniel Chmielewski > Subject: Fwd: please help with DBD-Oracle-1.76 > Date: 5 September 2022 at 10:03:15 IST > To: t...@cpan.org > > Tim, please help. > Regards, > Daniel > > > -- Forwarded mes

Please test DBD::Oracle v1.90_1

Hi All, Anyone using DBD::Oracle is invited to test out out this dev release v1.90_1 Download from metacpan https://metacpan.org/release/ZARQUON/DBD-Oracle-1.90_1 GH Tag https://github.com/perl5-dbi/DBD-Oracle/tree/v1.90_1 v1.90 candidate branch https://github.com/perl5-dbi/DBD-Oracle/tree

Re: [External] : DBD::Oracle use_drcp and connection class

On 5/3/2022 3:44 am, Andrei A. Voropaev via dbi-users wrote: Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers &quo

DBD::Oracle use_drcp and connection class

Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers "session pooling", which is not exactly the same. Connected

Re: DBD::Oracle insert speed

On 10/1/21 11:22 am, Peter Meszaros wrote: Hi, I have already asked this question at perlmonks.org <https://urldefense.com/v3/__http://perlmonks.org__;!!GqivPVa7Brio!OybtaVZUVoKl3qAbiNkFHQxZALNrn7ocQA5ft_OycHRoAtyyjCPfcy33Ob-PjpZEzbH1Ow$> but I did not get proper answer. Module DBD::

DBD::Oracle insert speed

Hi, I have already asked this question at perlmonks.org but I did not get proper answer. Module DBD::Oracle <http://search.cpan.org/perldoc?DBD%3A%3AOracle> has serious performance degradation at inserting rows. Except execute_array (or bind_param_array), all other insert solutions are

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

Actually, I did exactly this a few years ago. Only problem: NULLs show up as blanks ... Apart from that, it works like a charm! -- Peter Vanroose. Op 23 jun. 2020 22:10, om 22:10, "Fennell, Brian" schreef: >Another idea . . . > >You could also wrap Oracle SQLPlus in perl using qx > >How-to

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

Another idea . . . You could also wrap Oracle SQLPlus in perl using qx How-to SQLPLUS and XML here: https://asktom.oracle.com/pls/apex/f?p=100:11:0P11_QUESTION_ID:3512822500346787661 That and a little perl text parsing could get you a long way - split , grep, map, s and tr. This

RE: [EXTERNAL] Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

FYI The Oracle DBD driver is hard to build, it requires Oracle C Libraries and Header files. It also requires Oracle Development files described by Oracle as Examples, but which are really templates for building any C client. All Oracle C Clients are hard to build. If I recall sometimes a

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2e6444f43 in kputxabt () from > /u01/app/oracle/product/19.3.0.0/lib/libclntsh.so.19.1 > #2 0x7f82e926e6c3 in ora_db_rollback () from > /usr/local/perl-5.22.0-thr/lib/site_perl/5.22.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so > #3 0x7f82e9266b11 in XS_DBD__Oracle__db_D

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

On 6/20/20 1:51 PM, Scott wrote: More info, this error does not occur with DBD::Oracle 1.76. DBD::Oracle 1.80 => works with 18c client,  but fails with 19c. DBD::Oracle 1.76 => works with all client versions. On 6/19/20 5:48 PM, Scott wrote: We have run into an issue when we up

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

More info, this error does not occur with DBD::Oracle 1.76. DBD::Oracle 1.80 => works with 18c client,  but fails with 19c. DBD::Oracle 1.76 => works with all client versions. On 6/19/20 5:48 PM, Scott wrote: We have run into an issue when we upgraded to Oracle client 19c. Some of the

DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

  0x7f82e926e6c3 in ora_db_rollback () from /usr/local/perl-5.22.0-thr/lib/site_perl/5.22.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so #3  0x7f82e9266b11 in XS_DBD__Oracle__db_DESTROY () from /usr/local/perl-5.22.0-thr/lib/site_perl/5.22.0/x86_64-linux-thread-multi/auto/DBD/Oracle

Re: DBD::Oracle install issue on CentOS 8 missing libnsl

rrent Fedora build is) , and the > DBD::Oracle install fails during make test: > > Can't load > '/root/.cpan/build/DBD-Oracle-1.80-1/blib/arch/auto/DBD/Oracle/Oracle.so' for > module DBD::Oracle: libnsl.so.1: cannot open shared object file: No such file > or directory at /usr/lib64/perl5/Dy

DBD::Oracle install issue on CentOS 8 missing libnsl

Just a heads up for those of you on the close-to-the-bleeding-edge. libnsl is no longer included with the standard glibc libs with CentOS (and I'm guessing also in RHEL 8, and whatever the current Fedora build is) , and the DBD::Oracle install fails during make test: Can't load '/root/.cpan

DBD::Oracle - Error with Oracle Wallet

2.2 DBD::Oracle 1.74 Has anybody in this group faced this or similar issues? Any help will be appreciated. Thanks. -Rajesh Gandhi The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-

AIX (xlc) DBD::Oracle *without* LIBPATH?

Hi! I like to know: has anyone been able to get DBD::Oracle working on AIX (6 and/or 7) using the xlc compiler, *without* having to set LIBPATH *at runtime*?  I am able to get it to work by setting LIBPATH, but that's very distasteful and I'm trying to find a way to avoid it. On RHEL Linux, I'm

DBD-Oracle 1.79 released to the CPAN

I have just uploaded DBD::Oracle 1.79 to the CPAN.   [BUG FIXES]   Fix Avoid GCC-ism so that HP-UX can compile (GH#92, Dean Hamstead)   Destroy envhp with last dbh (GH#93, GH#89, Dean Hamstead, CarstenGrohmann) Thanks to everyone who contributed. Martin -- Martin J. Evans Wetherby, UK

RE: Hunting down (possible) memory leak in DBD::Oracle

grind errors". I can run the same case on an older version of perl and an older version of "DBD::Oracle" module (with the exact same oracle database) and get no errors. Valgrind documentation describes an "invalid write" as follows: http://valgrind.org/docs/manual/mc-manua

Re: Hunting down (possible) memory leak in DBD::Oracle

On 16/1/18 9:17 am, Fennell, Brian wrote: $ egrep -B1 -A20 -i 'invalid write' /copy/sandbox/feeds/data/search4_1/valgrind-log.txt | head -22 ==19402== ==19402== Invalid write of size 4 ==19402==at 0xBD747E6: __intel_ssse3_rep_memcpy (in

RE: Hunting down (possible) memory leak in DBD::Oracle

I got this case running with valgrind - Valgrind reported - 8 invalid writes, 8 invalid writes, 2239 accesses to uninitialized values. All invalid writes have a stack trace leading back to XS_DBD__Oracle__st_fetchrow_array (Oracle.xsi:662) and ora_st_fetch (oci8.c:4032) Details follow: export

RE: Hunting down (possible) memory leak in DBD::Oracle

John, Thanks for your incites. I tried what you said. I read up on NVARCHAR2 v VARCHAR2 - interesting.  I also see that Oracle has a way (more than one way) to specify if a VARCHAR2 should contain bytes or characters - further while a VARCHAR2(11 byte) and a VARCHAR2(11 char) are different

Re: Hunting down (possible) memory leak in DBD::Oracle

On 2017-12-19 20:55:30 +, Fennell, Brian wrote: > And, also with the log level set to 15 here are the LAST 200 lines [...] > -> fetchrow_array for DBD::Oracle::st > (AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010 > dbd_st_fetch 6 fields... >

RE: Hunting down (possible) memory leak in DBD::Oracle

858 at /dirname/scriptname.pl line 196 -> fetchrow_array for DBD::Oracle::st (AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010 dbd_st_fetch 6 fields... dbd_st_fetched 6 fields with status of 0(SUCCESS) field #1 with rc=0(OK) 3abd340 (f

RE: Hunting down (possible) memory leak in DBD::Oracle

With the log level set to 15 here are the first 200 lines of log AAA::DBI::Connection::db=HASH(0x3abce00) trace level set to 0x0/15 (DBI @ 0x0/0) in DBI 1.637-ithread (pid 12594) -> STORE for DBD::Oracle::db (AAA::DBI::Connection::db=HASH(0x3abce00)~INNER 'RowCacheSize' 2097152)

RE: Hunting down (possible) memory leak in DBD::Oracle

John, Thanks for the ideas to change the cache params - I will try that! Here is the SQL and the field types: SELECT d.ROW_NUMBER, d.f1, d.f2, d.f3, d.f4, d.f5 FROM ( SELECT /*+ FULL(A) PARALLEL(A 6) */ rownum ROW_NUMBER, A.field1 f1 ,

Re: Hunting down (possible) memory leak in DBD::Oracle

here. If could be running out of buffer. Give some of the caching params a tweak https://metacpan.org/pod/DBD::Oracle#RowCacheSize if you can try give fetchrow_hashref a try as see if the error happens there as well. Cheers John DBD::Oracle - Oracle database driver for the DBI module

RE: Hunting down (possible) memory leak in DBD::Oracle

Pluta, Looks like it is worth a try - when I looked at the project before it looked like it was for installing a "per user" perl. Does it work for root / all users on a box as well? Brian

RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL **

Subject: RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL ** Thanks for the reply, Howard, I am using the exact same database - a test database that has copies of the production data put into it once a day - besides that it doesn't change much (if at all) during the day. The SQ

RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL **

Ok . . . I am already benefiting from the support from this list : - ) I noticed that I was actually ordering my query BY rownum (which doesn't make much sense . . . and perhaps oracle's optimizer recognized this and ignored the pseudo column.) Just to be sure, I change the query and then

RE: Hunting down (possible) memory leak in DBD::Oracle

and the DBD::Oracle to the same version we use in production, but it would be nice to actually fix the bug if I can. I tried just downgrading the DBD::Oracle, but changes in perl 5 to support MULTIPLICITY made that look like more than just a little work - spend two days on it and then backed

RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL **

umber >= 100 -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Monday, December 18, 2017 9:21 AM To: Fennell, Brian <fenne...@radial.com>; dbi-users@perl.org Subject: RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL ** Same database... do

Re: Hunting down (possible) memory leak in DBD::Oracle

Hmm this type of DBD::Oracle debugging will be tricky. Could be almost anything. You are jumping versions in a big way but that still should be ok A few questions 1) What is the ORA-NN in question 2) Set trace to 15 to see if that give you more details 3) What are the type of fields

Hunting down (possible) memory leak in DBD::Oracle

it might be an odd string/data related error, but I am starting to think it is a memory leak of some kind). The error always happens inside of fetchrow_array - and "$dbh->trace( 4 , $filename )" shows that the error originates inside the DBD::Oracle module while reading field 3 of 6.

DBD::Oracle BLOB updates on multiple rows

Hi,? Running an update like below with DBD::Oracle that updates 2 rows with the same BLOB value bound as ORA_BLOB fails with the following inside oci8.c if (row_count > 1) return oci_error(sth, errhp, OCI_ERROR, "LOB refetch attempted for multiple rows"); and I'm

RE: (Fwd) DBD::Oracle quote_identifier

: Wednesday, August 17, 2016 4:25 AM To: dbi-users@perl.org Cc: LAWS, MICHAEL H <ml3...@att.com> Subject: (Fwd) DBD::Oracle quote_identifier - Forwarded message from "LAWS, MICHAEL H" <ml3...@att.com> - Date: Tue, 16 Aug 2016 21:04:20 + From: "LAWS, MICHAEL

(Fwd) DBD::Oracle quote_identifier

- Forwarded message from "LAWS, MICHAEL H" <ml3...@att.com> - Date: Tue, 16 Aug 2016 21:04:20 + From: "LAWS, MICHAEL H" <ml3...@att.com> To: "t...@cpan.org" <t...@cpan.org> Subject: DBD::Oracle quote_identifier Hello, I was usi

Re: Bundle::DBI and DBD::Oracle failing

racle.so? # file /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so What does ldd(1) report about missing dependencies? # ldd /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so Are the dependencies installed? Can you find(1) them? John groenv...@acm.org

RE: Bundle::DBI and DBD::Oracle failing

Does it still make a difference running it as 32-bit on a 64-bit machine. I`ve strictly been trying it on 64 bit. Regards, Tony. -Original Message- From: Tony D'Alfonso Sent: June 23, 2016 9:55 AM To: 'Bruce Johnson' Cc: dbi users Subject: RE: Bundle::DBI and DBD::Oracle failing

RE: Bundle::DBI and DBD::Oracle failing

. -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: June 22, 2016 5:12 PM To: Tony D'Alfonso Cc: dbi users Subject: Re: Bundle::DBI and DBD::Oracle failing > On Jun 22, 2016, at 1:26 PM, Tony D'Alfonso <tony.dalfo...@smi-ieso.ca> wrote: > > SD

Re: Bundle::DBI and DBD::Oracle failing

x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libstdc++.so.5: cannot open shared object file which suggests Oracle.so was built under /root/perl5 OTOH, as others suggested, the OP probably needs to 'yum install compat-libstdc++' (for RHEL/centos 6, which I believe is

Re: Bundle::DBI and DBD::Oracle failing

> On Jun 22, 2016, at 1:26 PM, Tony D'Alfonso wrote: > > SDK was installed too: > > # yum list oracle-instantclient* > Loaded plugins: product-id, search-disabled-repos, subscription-manager > Installed Packages > oracle-instantclient-basic.x86_64

Re: Bundle::DBI and DBD::Oracle failing

On Jun 22, 2016, at 1:34 PM, John R Pierce > wrote: if root installed it to /root, no other user can see or access that. running cpan as root is fine, since that doesn’t affect the permissions of the final perl executables. The only thing it

RE: Bundle::DBI and DBD::Oracle failing

...@pharmacy.arizona.edu] Sent: June 22, 2016 4:23 PM To: Tony D'Alfonso Cc: dbi users Subject: Re: Bundle::DBI and DBD::Oracle failing > On Jun 22, 2016, at 12:32 PM, Tony D'Alfonso <tony.dalfo...@smi-ieso.ca> > wrote: > > Hi Carl, > > I used CPAN to install them a

Re: Bundle::DBI and DBD::Oracle failing

On 6/22/2016 12:32 PM, Tony D'Alfonso wrote: I used CPAN to install them and it appeared as though they are in place: # cpan -i Bundle::DBI Reading '/root/.cpan/Metadata' Database was generated on Wed, 22 Jun 2016 13:29:02 GMT if root installed it to /root, no other user can see or access

Re: Bundle::DBI and DBD::Oracle failing

ted on Wed, 22 Jun 2016 13:29:02 GMT > DBI is up to date (1.636). > DBI::Shell is up to date (11.95). > Storable is up to date (2.51). > Net::Daemon is up to date (0.48). > RPC::PlServer is up to date (0.2020). > DBD::Multiplex is up to date (2.11). > [root@screendoor ~]# cpan -i

Re: Bundle::DBI and DBD::Oracle failing

s@perl.org> Subject: RE: Bundle::DBI and DBD::Oracle failing Confirming this email made it through. Slicing the output into multiple messages. Can you help me with this error message? perl /stl/bin/test.pl install_driver(Oracle) failed: Can't load '/root/perl5/lib/perl5/x86_64-linux-thread

RE: Bundle::DBI and DBD::Oracle failing

is up to date (0.48). RPC::PlServer is up to date (0.2020). DBD::Multiplex is up to date (2.11). [root@screendoor ~]# cpan -i DBD::Oracle Reading '/root/.cpan/Metadata' Database was generated on Wed, 22 Jun 2016 13:29:02 GMT DBD::Oracle is up to date (1.74). I'm using the Oracle 10 client

Re: Bundle::DBI and DBD::Oracle failing

. Slicing the output into multiple messages. Can you help me with this error message? perl /stl/bin/test.pl install_driver(Oracle) failed: Can't load '/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libstdc++.so.5: cannot open shared object file

RE: Bundle::DBI and DBD::Oracle failing

# perl -V Summary of my perl5 (revision 5 version 16 subversion 3) configuration: Platform: osname=linux, osvers=2.6.32-504.16.2.el6.x86_64, archname=x86_64-linux-thread-multi uname='linux x86-021.build.eng.bos.redhat.com 2.6.32-504.16.2.el6.x86_64 #1 smp tue mar 10

RE: Bundle::DBI and DBD::Oracle failing

Confirming this email made it through. Slicing the output into multiple messages. Can you help me with this error message? perl /stl/bin/test.pl install_driver(Oracle) failed: Can't load '/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle

Re: Help with DBD::Oracle install

On 05/02/2016 20:35, Tim Bunce wrote: Hi. I don't provide support for DBD::Oracle directly. Please email dbi-users@perl.org or, if you'd rather not just yet, then something here will probably help: https://www.google.com/search?q=dbd-oracle+/usr/ucb/cc:++language+optional+software+package

DBD::Oracle and RHEL Instant Client rpms

Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant client? I installed the Basic and Development IC rpm’s and the DBD installer complained it couldn’t determine what version I had, then complained it couldn’t find demo.mk. I finally got it to work by manually

Re: DBD::Oracle and RHEL Instant Client rpms

> On Oct 20, 2015, at 2:22 PM, Martin J. Evans <boh...@ntlworld.com> wrote: > > > I don't use an RPM based system. I download instantclient basic, devel and > sqlplus zips and unzip them then point DBD::Oracle at them by setting > LD_LIBRARY_PATH. > > Di

Re: DBD::Oracle and RHEL Instant Client rpms

On 20/10/2015 19:53, Bruce Johnson wrote: Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant client? I installed the Basic and Development IC rpm’s and the DBD installer complained it couldn’t determine what version I had, then complained it couldn’t find demo.mk

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

Hi! There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. I have that one (actually, those three), but they are nine years old as well: 20061115_5 is coded into the ports name. The API did

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

According to Kurt Jaeger dbi-us...@opsec.eu on Thu, 06/04/15 at 09:38: My guess: no-one had the need, time and skills to fix it. There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. I have that one

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

Hi! What is confusing to me is why FreeBSD _still_ contains DBD::Oracle 1.19 in their ports tree! After all these years! Because: DBD::Oracle no longer supports Oracle client versions before 9.2 Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

Hi! There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. I have that one (actually, those three), but they are nine years old as well: 20061115_5 is coded into the ports name. The API did

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

According to Kurt Jaeger dbi-us...@opsec.eu on Thu, 06/04/15 at 02:50: DBD::Oracle no longer supports Oracle client versions before 9.2 Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271. and there is no oracle9-client port on FreeBSD. Thanks. That makes sense

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

Hi! According to Kurt Jaeger dbi-us...@opsec.eu on Thu, 06/04/15 at 02:50: DBD::Oracle no longer supports Oracle client versions before 9.2 Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271. and there is no oracle9-client port on FreeBSD. Thanks

DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

in message 20150603172207.gf2...@itcom245.staff.itd.umich.edu, wrote William Bulley thusly... ... My focus now is trying to install DBD::Oracle 1.74 from CPAN (from April of 2014) on my system. ... What is confusing to me is why FreeBSD _still_ contains DBD::Oracle 1.19 in their ports tree

RE: (Fwd) Issue :DBD::Oracle installation

!!! Thanks and regards, Ranjitha M:  +91 9739463575 T: +91 8039136322 ranji...@infosys.com -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Monday, June 09, 2014 12:58 AM To: Ranjitha Subject: Re: (Fwd) Issue :DBD::Oracle installation On Jun 5, 2014

RE: (Fwd) Issue :DBD::Oracle installation

) Issue :DBD::Oracle installation - Forwarded message from Ranjitha ranji...@infosys.com - Date: Wed, 4 Jun 2014 11:05:34 + From: Ranjitha ranji...@infosys.com To: tim.bu...@pobox.com tim.bu...@pobox.com, t...@cpan.org t...@cpan.org Subject: Issue :DBD::Oracle installation Hi Tim

Re: (Fwd) Issue :DBD::Oracle installation

On 04/06/14 12:44, tim.bu...@pobox.com wrote: - Forwarded message from Ranjitha ranji...@infosys.com - Date: Wed, 4 Jun 2014 11:05:34 + From: Ranjitha ranji...@infosys.com To: tim.bu...@pobox.com tim.bu...@pobox.com, t...@cpan.org t...@cpan.org Subject: Issue :DBD::Oracle

Re: (Fwd) Issue :DBD::Oracle installation

saying you have not installed sqlplus. I was saying you need to make sure you can run sqlplus before attempting to build DBD::Oracle. So sqlplus should be on your PATH or findable under LD_LIBRARY_PATH which you should set and export. It is pointless trying to build DBD::Oracle if you cannot

(Fwd) Issue :DBD::Oracle installation

- Forwarded message from Ranjitha ranji...@infosys.com - Date: Wed, 4 Jun 2014 11:05:34 + From: Ranjitha ranji...@infosys.com To: tim.bu...@pobox.com tim.bu...@pobox.com, t...@cpan.org t...@cpan.org Subject: Issue :DBD::Oracle installation Hi Tim Facing an issue while

RE: FW: Perl module DBD::Oracle installation failing

: ramakrishna.jillape...@xerox.com, Ph: +1-214-530-, Ext 3208, Mob: +91-9008177255 (Off), +91-9880678154 (Per). -Original Message- From: Jillapelli, Ramakrishna Sent: Monday, April 07, 2014 9:35 PM To: 'Kurt Jaeger' Cc: dbi-users@perl.org Subject: RE: FW: Perl module DBD::Oracle

FW: Perl module DBD::Oracle installation failing

Hi, Can you please help me, how to fix the issue and install Perl DBD::Oracle module. Thanks Regards, Ramakrishna Jillapelli, Global Services, Operations and Engineering, XEROX Business Services, 9th Floor, Explorer Block, White Field Road, ITPL, Bangalore - 560066, India. E-Mail

RE: FW: Perl module DBD::Oracle installation failing

: ramakrishna.jillape...@xerox.com, Ph: +1-214-530-, Ext 3208, Mob: +91-9008177255 (Off), +91-9880678154 (Per). -Original Message- From: Kurt Jaeger [mailto:p...@opsec.eu] Sent: Monday, April 07, 2014 8:25 PM To: Jillapelli, Ramakrishna Subject: Re: FW: Perl module DBD::Oracle installation failing

make test failed for perl module DBD-Oracle-1.70

Hi, struck with DBD-Oracle-1.70 Make test returned the following error: cp lib/DBD/Oracle/Troubleshooting/Win32.pod blib/lib/DBD/Oracle/Troubleshooting/Win32.pod cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm /usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists(NAME = DBD::Oracle

Re: make test failed for perl module DBD-Oracle-1.70

On 19/03/2014 18:31, Jillapelli, Ramakrishna wrote: Hi, struck with “DBD-Oracle-1.70” You are likely to get more/better help if you tell us more. Platform? Perl version and where it came from? compiler? Oracle you are compiling against - full Oracle or Instant Client and version? Anyway

RE: Surprising DBD::Oracle error raised

way is to fetch is in a loop with 'while'. As there is no way to tell how many records will be in your set before you do you SQL unless you tell the SQL to return only x rows. Cheers John Date: Tue, 4 Feb 2014 13:36:50 -0600 Subject: Surprising DBD::Oracle error raised From: davidni

Re: Surprising DBD::Oracle error raised

$row\n; I get: 1 Use of uninitialized value $row in concatenation (.) or string at mje/fetch_off_end.pl line 20. However, I get the same with DBD::Oracle so how is you code different from the above. Martin

RE: Surprising DBD::Oracle error raised

, 5 Feb 2014 13:25:03 + From: martin.ev...@easysoft.com To: davidni...@gmail.com; dbi-users@perl.org Subject: Re: Surprising DBD::Oracle error raised On 04/02/14 19:36, David Nicol wrote: $price_sth-execute; my ($o_file_price) = $price_sth-fetchrow_array(); if ($price_sth-fetch

Re: Surprising DBD::Oracle error raised

: Surprising DBD::Oracle error raised On 04/02/14 19:36, David Nicol wrote: $price_sth-execute; my ($o_file_price) = $price_sth-fetchrow_array(); if ($price_sth-fetch) { $this-log_error('ERROR: scalar select returned second row at %s line %d', __FILE__, __LINE__); } I

Re: Surprising DBD::Oracle error raised

In message cafwsco-tqp5yycpptawzqkkyhz6qjs3d_g+yv5r9x9apdbm...@mail.gmail.com , David Nicol writes: the error message claimed I hadn't executed the statement. Where is your DBI_TRACE? I can't reproduce. John groenv...@acm.org use strict; use DBI; my $dbh = DBI-connect( dbi:Oracle:, scott,

Re: Surprising DBD::Oracle error raised

; I get: 1 Use of uninitialized value $row in concatenation (.) or string at mje/fetch_off_end.pl line 20. However, I get the same with DBD::Oracle so how is you code different from the above. Martin The code is the same. Rather, close enough, my second fetch was in boolean context

Re: Surprising DBD::Oracle error raised

; # fetch status print $row\n; I get: 1 Use of uninitialized value $row in concatenation (.) or string at mje/fetch_off_end.pl line 20. However, I get the same with DBD::Oracle so how is you code different from the above. Martin The code is the same. Rather, close enough, my second fetch

Surprising DBD::Oracle error raised

$price_sth-execute; my ($o_file_price) = $price_sth-fetchrow_array(); if ($price_sth-fetch) { $this-log_error('ERROR: scalar select returned second row at %s line %d', __FILE__, __LINE__); } I expected the fetch to return undef, but it throws an Oracle error. My best

Re: Surprising DBD::Oracle error raised

In message CAFwScO-0DchsbSLPSmR9JY+KmBUF3BfUREH9XdDSVgEAo=p...@mail.gmail.com , David Nicol writes: $price_sth-execute; my ($o_file_price) = $price_sth-fetchrow_array(); if ($price_sth-fetch) { $this-log_error('ERROR: scalar select returned second row at %s line %d', __FILE__,

Re: Surprising DBD::Oracle error raised

} and $price_sth-fetch) { $this-log_error('ERROR: scalar select returned second row at %s line %d', __FILE__, __LINE__); } but if that's the right thing to do, the documentation (in DBD::Oracle) should mention it in fetchrow_array's section IMO. -- The one L lama, he's a priest The two L llama

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

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

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

On Jan 27, 2014, at 12:04 PM, Alexander Foken alexan...@foken.de 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,

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

On Jan 27, 2014, at 12:25 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: On Jan 27, 2014, at 12:04 PM, Alexander Foken alexan...@foken.de 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

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

:04 AM Subject: Re: Getting Error Message Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll While Connecting to Oracle 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

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

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 full error message: Can't load 'C

Build error - DBD::Oracle, Oracle 11.2.0.1, 32-bit client, remote DB

I'm trying to build DBI and DBD::Oracle to run on a Linux server (2.6.18-274.7.1.el5) using the 11g (11.2.0.1) 32-bit client. The database resides on a remote server and I can get to it just fine using sqlplus. Here is the output from the make: mvaughan - ni00 - /u/mvaughan/.cpan/build/DBD

Re: Build error - DBD::Oracle, Oracle 11.2.0.1, 32-bit client, remote DB

In message 55bc400cff41a94aae7062ab10940b3f022...@stntexmb12.cis.neustar.com, Vaughan, Mark writes: I'm trying to build DBI and DBD::Oracle to run on a Linux server (2.6.18-27= 4.7.1.el5) using the 11g (11.2.0.1) 32-bit client. The database resides on = Your perl must be 32-bit to build 32-bit

Re: DBD::Oracle installation

different installation scenarios and platforms. I think the most 'common' method nowadays would be to use the Oracle InstantClient. A couple months ago I added installation instructions to the OTRS manual for how to compile DBD::Oracle on different platforms for usage with the OTRS software. It might

DBD::Oracle installation

features of DBD::Oracle may not work. Oracle version based logic in Makefile.PL may produce erroneous results. You can use perl Makefile.PL -V X.Y.Z to specify a your client version. Now if I had to specify that manually is that the sqlplus version?? How is it determining that version?? We have 12.4

Re: DBD::Oracle installation

is having trouble finding the version: WARNING: I could not determine Oracle client version so I'll just default to version 8.0.0.0. Some features of DBD::Oracle may not work. Oracle version based logic in Makefile.PL may produce erroneous results. You can use perl Makefile.PL -V X.Y.Z

(Fwd) Problems with DBD::Oracle package: function plsql_errstr

- Forwarded message from Eljot na Onet.pl eljot_...@poczta.onet.pl - Date: Sat, 02 Nov 2013 21:11:48 +0100 From: Eljot na Onet.pl eljot_...@poczta.onet.pl To: t...@cpan.org Subject: Problems with DBD::Oracle package: function plsql_errstr Hi, I have found two problems with your DBD

Re: (Fwd) Problems with DBD::Oracle package: function plsql_errstr

::Oracle package: function plsql_errstr Hi, I have found two problems with your DBD::Oracle package. (you have all examples in the attachment plsql_errstr.zip, please read README.txt file) which was missing unfortunately - perhaps when it was forwarded on. problems concern sub plsql_errstr

RE: Failed DBD oracle module

: john...@pharmacy.arizona.edu CC: dbi-users@perl.org Subject: Re: Failed DBD oracle module Date: Mon, 23 Sep 2013 21:09:34 + On Sep 23, 2013, at 2:02 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: This can happen if you have 32-bit oracle db installed on the system, but use

Failed DBD oracle module

Hi, I had installed perl 5.18.1 and two other modules DBI and DBD::Oralce. And using the simple script below to test both modules, DBI worked but DBD::Oracle gives the following errors. Both modules compile and installed without errors. - Testing module DBI worked: $ vi

  1   2   3   4   5   6   7   8   9   10   >