Re: DBD::Oracle OS authentication broken following Oracle 19.25 upgrade

Hey Greg - yeah, my current workaround is to connect with sys/password, but that's not the same as the original bequeath connection ( i.e., connecting with / ) (which is documented here: https://metacpan.org/pod/DBD::Oracle#OS-authentication). I'll reach out to the maintainer. Rob On Monday,

Re: DBD::Oracle OS authentication broken following Oracle 19.25 upgrade

Looks like Oracle tightened up its checks. Have you tried simply using a non-zero-length password string? You could also reach out directly to the current maintainer: https://metacpan.org/author/ZARQUON Cheers, Greg

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

To follow up, with the hackaround in the previous post, and modify test.pl to dispatch batches of 20 children, it eventually dies with a segfault (below - coredump available on request). Although I can not be sure if this is related to my hack, or the core library. Thanks, Justin    Mess

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 but I did not get proper answer. Module DBD::Oracle

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 SQLPL

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 pure-perl

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 li

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

> On Jun 19, 2020, at 3:48 PM, Scott wrote: > > We have run into an issue when we upgraded to Oracle client 19c. Some of the > users processes are segfaulting on exit. > > #0 0x7f82ee84ccc0 in pthread_mutex_lock () from /lib64/libpthread.so.0 > #1 0x7f82e6444f43 in kputxabt () from

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 upgraded to Oracle

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 users pr

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

> On Feb 18, 2020, at 9:58 AM, Bruce Johnson > wrote: > > 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

Re: DBD::Oracle and RHEL Instant Client rpms

> On Oct 20, 2015, at 2:22 PM, Martin J. Evans 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. > > Did you download the sqlplus RPM (assuming there is one) as DB

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. >

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 n

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

According to Kurt Jaeger 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 (actually, thos

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

Hi! > According to Kurt Jaeger 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)

According to Kurt Jaeger 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. What doesn't ma

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. and there is no

Re: DBD::Oracle installation

Hi Carl, On Fri, Dec 6, 2013 at 1:06 AM, Furst, Carl wrote: > However, I'm wondering why this information is not in the INSTALL file at > least? Would be a good hint so people know what they would need to get > going. > It could be one of the reasons is there are so many different installation

Re: DBD::Oracle installation

Thanks! We got it going with an oracle client rpm, sqlplus and demo.mk probably from SDK packages. Seems to be working. However, I'm wondering why this information is not in the INSTALL file at least? Would be a good hint so people know what they would need to get going. Thanks, Carl Furst O

Re: DBD::Oracle installation on AIX

"dbi-users@perl.org" *Sent:* Monday, September 23, 2013 12:32 PM *Subject:* Re: DBD::Oracle installation on AIX On 22/09/2013 22:41, Nagendra Singh wrote: > Hi Martin, > Thanks a bunch for looking into this problem. Here are the details asked > by you:- > PERL Version is

Re: DBD::Oracle installation on AIX

ndra Singh *Cc:* Michael Nhan ; Manimegalai Visvanathan ; "'dbi-users@perl.org'" *Sent:* Sunday, September 22, 2013 11:51 AM *Subject:* Re: DBD::Oracle installation on AIX On 21/09/2013 19:42, Nagendra Singh wrote: > Hi, > I have installed DBD::ODBC latest version on 64

Re: DBD::Oracle installation on AIX

On 21/09/2013 19:42, Nagendra Singh wrote: Hi, I have installed DBD::ODBC latest version on 64 bit Linux Machine. One one machine I am able to make connection to Vertica using DSN but on other machine I am getting following error message. My odbc.ini, odbcinst.ini files are matching exactly:- set

Re: DBD::Oracle installation on AIX

c: "'dbi-users@perl.org'" Sent: Friday, September 13, 2013 2:46 PM Subject: RE: DBD::Oracle installation on AIX Hi, Where does your oracle installation reside?  Did you install the oracle aix client/aix-instant client?  Is there a libclntsh.so somewhere in those paths you l

Re: DBD::Oracle installation on AIX

On 12/09/2013 23:13, Manimegalai Visvanathan wrote: Hi Team, I need one help from you… While installing in DBD::Oracle perl module am facing some challenges. Can you please help me to fix that issue. Server OS: AIX Am not able to run the make command: Some of the files you need to build DB

Re: DBD::Oracle installation on AIX

is oracle libraries and installation really in /app/oracle/client/jdk/jre? oracle library is needed for DBD-Oracle. Oracle binary is not the same as the Java from oracle. Just making sure you were not confusing the 2. Michael On Thu, 12 Sep 2013, Manimegalai Visvanathan wrote: Date: Thu,

Re: DBD::Oracle installation on AIX

On 9/12/2013 3:13 PM, Manimegalai Visvanathan wrote: export ORACLE_HOME=/app/oracle/client/jdk/jre that likely should be something more like... export ORACLE_HOME=/app/oracle/product/11.2.0.3 (Adjust to suit) -- john r pierce 37N 122W somewhere on

RE: DBD::Oracle installation on AIX

wrote: Date: Fri, 13 Sep 2013 12:34:53 -0700 From: Manimegalai Visvanathan To: 'Michael Nhan' Cc: "'dbi-users@perl.org'" Subject: RE: DBD::Oracle installation on AIX Hi Michael, Thanks for your reply :) Can you please let me know, which path I have to export t

RE: DBD::Oracle installation on AIX

-Original Message- From: Michael Nhan [mailto:mn...@genome.wustl.edu] Sent: Friday, September 13, 2013 12:29 PM To: Manimegalai Visvanathan Cc: 'dbi-users@perl.org' Subject: Re: DBD::Oracle installation on AIX is oracle libraries and installation really in /app/oracle/client/jdk/jre? orac

Re: DBD::Oracle Schema different than User question

On 12/11/12 21:27, Kevin L. Kane wrote: Yes I understand that what I am trying to do is "broken" from a Oracle perspective. The specific issue I am running into is that my application environment is only allowed to connect to the DB as one user/schema. I want to use dbicdump on other schemas ho

Re: DBD::Oracle Schema different than User question

Yes I understand that what I am trying to do is "broken" from a Oracle perspective. The specific issue I am running into is that my application environment is only allowed to connect to the DB as one user/schema. I want to use dbicdump on other schemas however, and its not just like a couple. It

Re: DBD::Oracle Schema different than User question

Switching schemas in Oracle makes no sense, because schemas are tied to the user. In fact you don't login to oracle with a username but with a schema name. Schema and username are the same things. It is not like MySQL where you have Databases that denote these object groups and are separate from us

RE: DBD::Oracle Schema different than User question

> Date: Mon, 12 Nov 2012 19:04:56 + > From: martin.ev...@easysoft.com > To: dbi-users@perl.org > CC: kevin.k...@gmail.com > Subject: Fwd: DBD::Oracle Schema different than User question > > Hi Kevin, > > I've forwarded your email on to the dbi-users li

Re: DBD::Oracle Schema different than User question

I've never had a need to have it set in the connect string because our logon trigger sets it for us based on a variety of criteria. execute immediate 'ALTER SESSION SET CURRENT_SCHEMA = SOMESCHEMA'; Matt On Mon, Nov 12, 2012 at 1:04 PM, Martin J. Evans wrote: > Hi Kevin, > > I've forward

Re: DBD::Oracle RTs a summary and request for help

On 27/06/12 09:01, Martin Hall wrote: On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to

Re: DBD::Oracle RTs a summary and request for help

On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone quiet

Re: DBD::Oracle RTs a summary and request for help

On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone quiet

Re: DBD::Oracle RTs a summary and request for help

On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone quiet. This looks like Oracle Bug 57598

Re: DBD::Oracle build on aix 6.1 ( host is 64 bit db server )

On 2012-05-20 16:05:31 -0400, John Scoles wrote: > Short answer no. I would not see any reason why you would need to > install the instance client as well. > > In the long run it depends on what you are doing. If you are going to > use perl for only loacal access then no need for the instanct c

Re: DBD::Oracle build on aix 6.1 ( host is 64 bit db server )

install the 'Oracle Instant Client' before attempting > the build of DBD::Oracle? Thought above post might never show, so I posted to comp.perl.misc, and Ben had a response. Please comment/thanks much: --snip Newsgroups: comp.lang.perl.misc Subject: Re: DBD::Oracle build on aix 6.1

RE: DBD::Oracle build on aix 6.1 ( host is 64 bit db server )

Short answer no. I would not see any reason why you would need to install the instance client as well. In the long run it depends on what you are doing. If you are going to use perl for only loacal access then no need for the instanct cleint. If you want to use Perl for say connecting via

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

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

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

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

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

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 each param a quick kludge only. If I get a little time this

Re: DBD::Oracle not utf8 encoding PL/SQL out values

On 07/02/12 09:28, Martin J. Evans wrote: On 07/02/12 04:56, Steve Baldwin wrote: #!/usr/bin/perl -w use strict; use warnings; use DBI; use Encode; sub main { my $dbh = DBI->connect( 'dbi:Oracle:', 'usr/pwd@instance', '', { PrintError => 0, AutoCommit => 0, RaiseError => 1, }, ); print {*STDERR

Re: DBD::Oracle not utf8 encoding PL/SQL out values

On 07/02/2012 19:42, Steve Baldwin wrote: Thanks a lot Martin. Created https://rt.cpan.org/Public/Bug/Display.html?id=74753. Cheers, Steve Could you post on the rt if you apply the patch and it works for you. Thanks Martin On Tue, Feb 7, 2012 at 8:28 PM, Martin J. Evans wrote: On 07/0

Re: DBD::Oracle not utf8 encoding PL/SQL out values

Thanks a lot Martin. Created https://rt.cpan.org/Public/Bug/Display.html?id=74753. Cheers, Steve On Tue, Feb 7, 2012 at 8:28 PM, Martin J. Evans wrote: > On 07/02/12 04:56, Steve Baldwin wrote: > >> #!/usr/bin/perl -w >> use strict; >> use warnings; >> use DBI; >> use Encode; >> >> sub main {

Re: DBD::Oracle not utf8 encoding PL/SQL out values

On 07/02/12 04:56, Steve Baldwin wrote: #!/usr/bin/perl -w use strict; use warnings; use DBI; use Encode; sub main { my $dbh = DBI->connect( 'dbi:Oracle:', 'usr/pwd@instance', '', { PrintError => 0, AutoCommit => 0, RaiseError => 1, }, );

Re: DBD::Oracle on OSX Lion (64-bit)

On 25/01/12 09:00, Jonas Brømsø Nielsen wrote: Hello, According to the documentation shipped with DBD::Oracle 1.38 it is specified that the Oracle 64-bit drivers are not working with OSX Lion, but no version of the drivers is mentioned. Can somebody confirm that this is version: 10.2.0.4? Ref:

Re: DBD::Oracle on RHEL5 [2.6.18-164.el5 albiet not really relevant] x86_64

On 21/11/11 16:48, Jess Portnoy wrote: Hello list, I used the following RPMs by Oracle: oracle-instantclient11.2-basic-11.2.0.2.0-1 oracle-instantclient11.2-devel-11.2.0.2.0-1 Install sqlplus because I believe without it the Makefile.PL will struggle to find the version of your client and wit

Re: DBD-Oracle - obtaining OCI handles from $dbh

On Fri, Oct 28, 2011 at 11:09:20AM -0400, Lyle Brooks wrote: > > The only other comment I have on that approach is that the� > interface comes out looking very C-like...meaning, the Perl > interface looks almost like the OCI C interface, which is > not too surprising. I found myself wishing that

Re: DBD-Oracle - obtaining OCI handles from $dbh

On Fri, Oct 28, 2011 at 05:19:33PM +0100, Martin J. Evans wrote: > On 28/10/2011 16:34, Charles Jardine wrote: > >I still use Oracle::OCI. There is a patch below which may > >allow you to build it under Oracle 11.2. > > > >As you will see, I have kept it going by botching things. > >Whenever a new

Re: DBD-Oracle - obtaining OCI handles from $dbh

On 28/10/2011 16:34, Charles Jardine wrote: On 28/10/11 16:09, Lyle Brooks wrote: Tim, I have looked at the Oracle::OCI module. I really like the concept, and it would undeniably be an extremely useful and powerful tool. However, I couldn't get it to work (by that I mean...I couldn't get it t

Re: DBD-Oracle - obtaining OCI handles from $dbh

e pointers. Quoting John Scoles (byter...@hotmail.com): Date: Thu, 27 Oct 2011 14:14:03 -0400 From: bro...@deseret.com To: martin.ev...@easysoft.com CC: dbi-users@perl.org Subject: Re: DBD-Oracle - obtaining OCI handles from $dbh Thanks for those pointers. I do agree with what Martin points ou

Re: DBD-Oracle - obtaining OCI handles from $dbh

On 28/10/11 16:09, Lyle Brooks wrote: > Tim, > > I have looked at the Oracle::OCI module. I really like the > concept, and it would undeniably be an extremely useful and > powerful tool. However, I couldn't get it to work (by that > I mean...I couldn't get it to build). I still use Oracle::OCI.

RE: DBD-Oracle - obtaining OCI handles from $dbh

cted/wanted. > > > > I haven't yet tested that I can now pass these pointer values to > > the C++ libraries and have them digest it properly...but that would > > be next. > > > > As for how much anyone else might find use for thisproba

Re: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

> be next. > > As for how much anyone else might find use for thisprobably not > a wide audience. But it is a nice hack! > > Thanks for the pointers. > > Quoting John Scoles (byter...@hotmail.com): > > > > > > > Date: Thu, 27

RE: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

Glad we can help. Keep us informed on how it works out cheers John > Date: Thu, 27 Oct 2011 14:39:15 -0400 > From: bro...@deseret.com > To: byter...@hotmail.com > CC: martin.ev...@easysoft.com; dbi-users@perl.org > Subject: Re: DBI-Users> RE: DBD-Oracle - obtaining OCI

Re: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

. But it is a nice hack! Thanks for the pointers. Quoting John Scoles (byter...@hotmail.com): > > > > Date: Thu, 27 Oct 2011 14:14:03 -0400 > > From: bro...@deseret.com > > To: martin.ev...@easysoft.com > > CC: dbi-users@perl.org > > Subject: Re: DBD-Ora

RE: DBD-Oracle - obtaining OCI handles from $dbh

> Date: Thu, 27 Oct 2011 14:14:03 -0400 > From: bro...@deseret.com > To: martin.ev...@easysoft.com > CC: dbi-users@perl.org > Subject: Re: DBD-Oracle - obtaining OCI handles from $dbh > > > Thanks for those pointers. > > I do agree with what Martin points out.

RE: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

> Date: Thu, 27 Oct 2011 18:42:23 +0100 > From: martin.ev...@easysoft.com > To: dbi-users@perl.org > Subject: Re: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh > > On 27/10/2011 17:43, John Scoles wrote: > > Hmm!! > > > > Well y

Re: DBD-Oracle - obtaining OCI handles from $dbh

that small 'c' wrapper to fire your > >function. > > > My impression was that this was already done. > I quote: > > "I have created some Perl bindings for some existing custom C++ libraries." > > Martin > -- > > Martin J. Evans > E

Re: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

t;I have created some Perl bindings for some existing custom C++ libraries." Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Hope this helps Cheers John Date: Thu, 27 Oct 2011 09:48:54 -0400 From: bro...@deseret.com To: byter...@hotmail.com CC: dbi-users@perl.org Subjec

RE: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

er to fire your function. Hope this helps Cheers John > Date: Thu, 27 Oct 2011 09:48:54 -0400 > From: bro...@deseret.com > To: byter...@hotmail.com > CC: dbi-users@perl.org > Subject: Re: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh > > Yes, I assumed I

Re: DBI-Users> RE: DBD-Oracle - obtaining OCI handles from $dbh

Yes, I assumed I would need to extend DBD::Oracle is some manner to allow those handles to be extracted from a $dbh object. The specific OCI handles that the C++ libraries use are - Environment handle - Service Context handle - Session handle - Server handle My initial thought process on how it

RE: DBD-Oracle - obtaining OCI handles from $dbh

> Date: Wed, 26 Oct 2011 21:46:30 -0400 > From: bro...@deseret.com > To: dbi-users@perl.org > Subject: DBD-Oracle - obtaining OCI handles from $dbh > > I have created some Perl bindings for some existing custom C++ > libraries. > > One of these C++ libraries implements a class that uses Ora

Re: DBD-Oracle - obtaining OCI handles from $dbh

On 27/10/2011 02:46, Lyle Brooks wrote: I have created some Perl bindings for some existing custom C++ libraries. One of these C++ libraries implements a class that uses Oracle OCI calls. I would like to create a connection to the Oracle database using Perl's DBI (DBD::Oracle) module, and then

Re: DBD::Oracle 1.32 Compile Errors : Oracle.c: In function ‘XS_DBD__Oracle__db_ora_db_startup’ and more....help?

On 21/10/11 16:53, James Freire wrote: Hi All, I've been banging my head against the desk trying to get DBD::Oracle to compile on Redhat (Linux 2.6.18-238.1.1.el5 #1 SMP Tue Jan 4 13:32:19 EST 2011 x86_64 x86_64 x86_64 GNU/Linux). Oracle version 10.1.0.5 (10.1) I read through the supporting do

RE: DBD::Oracle 1.25 and DRCP

bound to be a few that slip though the cracks. Cheers John Scoles > Date: Sat, 15 Oct 2011 15:24:59 -0400 > Subject: Re: DBD::Oracle 1.25 and DRCP > From: frie...@gmail.com > To: byter...@hotmail.com > CC: dbi-users@perl.org > > Thanks John! > > that seems to have

Re: DBD::Oracle 1.25 and DRCP

LS env > > Just need to connect no need for any qurreries etc > > cheers > John Scoles > >> Date: Fri, 14 Oct 2011 18:53:09 -0400 >> Subject: Re: DBD::Oracle 1.25 and DRCP >> From: frie...@gmail.com >> To: byter...@hotmail.com >> CC: dbi-users@perl.org >&

RE: DBD::Oracle 1.25 and DRCP

ould (if it can) show you some place in the trace Useing DRCP Connection just after it reports on your NLS env Just need to connect no need for any qurreries etc cheers John Scoles > Date: Fri, 14 Oct 2011 18:53:09 -0400 > Subject: Re: DBD::Oracle 1.25 and DRCP > From: frie...@g

Re: DBD::Oracle 1.25 and DRCP

g on. > > Just do a simple connect no need for any other DBI stuff. > > I would also give the other flavours of connecting a try as well > > Cheers > John > >> Date: Fri, 14 Oct 2011 15:06:48 -0400 >> Subject: Re: DBD::Oracle 1.25 and DRCP >> From: frie...@gm

RE: DBD::Oracle 1.25 and DRCP

ive the other flavours of connecting a try as well Cheers John > Date: Fri, 14 Oct 2011 15:06:48 -0400 > Subject: Re: DBD::Oracle 1.25 and DRCP > From: frie...@gmail.com > To: dbi-users@perl.org > > Hey Cliff and John, > > on Sept 22, 2010 you posted about issues y

Re: DBD::Oracle 1.25 and DRCP

Hey Cliff and John, on Sept 22, 2010 you posted about issues you were having with getting Oracle DRCP working using the ora_drcp_class. I am running into similar issues and was wondering if you got DRCP to work and have it share the connection. We are using oracle 11.2.0.2 and I have perl v5.8.8,

Re: (Fwd) Re: DBD::Oracle Slow cursors

On 19/05/11 10:28, P S Jameel Ahamed wrote: > I tried a simple SQL with 100 records in the table and refcursor. The SQL > response if I fire it in SQL developer or TOAD is 0.09 seconds > > But If I fire the same thing in Java program below is the analysis. You can > clearly see that the when sta

RE: (Fwd) Re: DBD::Oracle Slow cursors

27;Tim Bunce' Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors Try doing a very simple refcursor and see if you still have the same performance issues. John From: P S Jameel Ahamed [mailto:jaha...@idexcel.com] Sent: Wednesday, May 18, 2011 5:04 AM To: 'John Scoles'; &#x

RE: (Fwd) Re: DBD::Oracle Slow cursors

'; 'Martin Evans'; dbi-users@perl.org; 'Tim Bunce' Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors When I say simple, I mean on a table with just a few rows. You may want to look at how many rows are pulled back from the database at a time on your large table (batching

RE: (Fwd) Re: DBD::Oracle Slow cursors

:46 AM To: P S Jameel Ahamed; 'John Scoles'; 'Martin Evans'; dbi-users@perl.org; 'Tim Bunce' Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors Try doing a very simple refcursor and see if you still have the same performance issues. John From: P S Jameel Ahamed [ma

RE: (Fwd) Re: DBD::Oracle Slow cursors

___ From: John Scoles [mailto:byter...@hotmail.com] Sent: 18 May 2011 12:21 To: jaha...@idexcel.com; Martin Evans; dbi-users@perl.org; carlso...@llnl.gov; Tim Bunce Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors Does this have anything to do at all with DBD::Oracle??? You mentioned you are calling

RE: (Fwd) Re: DBD::Oracle Slow cursors

12:21 To: jaha...@idexcel.com; Martin Evans; dbi-users@perl.org; carlso...@llnl.gov; Tim Bunce Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors Does this have anything to do at all with DBD::Oracle??? You mentioned you are calling this with JAVA?? Where is the Perl code?? > From: jaha...@ide

RE: (Fwd) Re: DBD::Oracle Slow cursors

here. Perhaps you should rethink the refcursor idea or try spliting it up into two or more calls Cheers From: jaha...@idexcel.com To: byter...@hotmail.com; martin.ev...@easysoft.com; dbi-users@perl.org; carlso...@llnl.gov; tim.bu...@pobox.com Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors

RE: (Fwd) Re: DBD::Oracle Slow cursors

Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors > Date: Wed, 18 May 2011 11:07:56 +0100 > > Hi All, > > First of all I thank you all in replying to my email. Below are details of > one of the SP which we are having issues with. > > In the below SP we are passing in a

RE: (Fwd) Re: DBD::Oracle Slow cursors

D M.country_code = C.country_code) ); OPEN rcSelectDashBoard FOR SELECT dashboard_type as type, rec_count as count, average_age, count_above_5days, count_closed_5days, avg_response_time FROM tbl_qm_dashboard; END sp_select_dashboard

Re: (Fwd) Re: DBD::Oracle Slow cursors

On 17/05/2011 22:18, Tim Bunce wrote: - Forwarded message from P S Jameel Ahamed - Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamed To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11 HI Tim, We are facing huge

RE: (Fwd) Re: DBD::Oracle Slow cursors

> Date: Tue, 17 May 2011 22:18:22 +0100 > From: tim.bu...@pobox.com > To: dbi-users@perl.org > CC: jaha...@idexcel.com > Subject: (Fwd) Re: DBD::Oracle Slow cursors > > - Forwarded message from P S Jameel Ahamed - > > Date: Tue, 17 May 2011 16:11:04 +0100 >

RE: (Fwd) Re: DBD::Oracle Slow cursors

bject: (Fwd) Re: DBD::Oracle Slow cursors - Forwarded message from P S Jameel Ahamed - Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamed To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11 HI Tim, We are facing huge i

Re: (Fwd) Re: DBD::Oracle Slow cursors

Tim Bunce schrieb am 17.05.2011 um 22:18 (+0100): > - Forwarded message from P S Jameel Ahamed >We are facing huge issues with the SYS_refcurors of oracle > 10G when returning from Stored procedure. Is there any solution > you found for the issue? Care to expand a little on what precisel

(Fwd) Re: DBD::Oracle Slow cursors

- Forwarded message from P S Jameel Ahamed - Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamed To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11 HI Tim, We are facing huge issues with the SYS_refcurors of oracle 10G

Re: DBD::Oracle 1.27 and bind_col()

On 25.03.2011 12:16, Martin J. Evans wrote: On 25/03/11 11:06, Martin J. Evans wrote: On 24/03/11 15:26, Alexander Foken wrote: Hello List, could someone with a working DBD::Oracle 1.28 please verify that the tests 2 and 4 in the attached test script fail? All test pass with DBD::Oracle 1.2

Re: DBD::Oracle 1.27 and bind_col()

On 25.03.2011 12:16, Martin J. Evans wrote: On 25/03/11 11:06, Martin J. Evans wrote: On 24/03/11 15:26, Alexander Foken wrote: Hello List, could someone with a working DBD::Oracle 1.28 please verify that the tests 2 and 4 in the attached test script fail? All test pass with DBD::Oracle 1.2

Re: DBD::Oracle 1.27 and bind_col()

On 25/03/11 11:06, Martin J. Evans wrote: On 24/03/11 15:26, Alexander Foken wrote: Hello List, could someone with a working DBD::Oracle 1.28 please verify that the tests 2 and 4 in the attached test script fail? All test pass with DBD::Oracle 1.23, tests 2 and 4 fail with DBD::Oracle 1.27.

Re: DBD::Oracle 1.27 and bind_col()

On 24/03/11 15:26, Alexander Foken wrote: Hello List, could someone with a working DBD::Oracle 1.28 please verify that the tests 2 and 4 in the attached test script fail? All test pass with DBD::Oracle 1.23, tests 2 and 4 fail with DBD::Oracle 1.27. Background information: I use Perl to provi

RE: DBD::Oracle 1.27 and bind_col()

I will have to look into this one in detail later next week as I am off at a conferace this week. Seems like something got in there. can you send me run with DBD_Verbose=7 Cheers John > Date: Thu, 24 Mar 2011 16:26:00 +0100 > From: alexan...@foken.de > To: dbi-users@perl.org > Subject: DBD:

Re: (Fwd) Re: DBD::Oracle: table_info, PUBLIC schema

On 21/03/2011 2:49 PM, Tim Bunce wrote: - Forwarded message from Satish Patil - Date: Mon, 21 Mar 2011 07:37:45 -0700 (PDT) From: Satish Patil To: tim.bu...@pobox.com, s.goeld...@eurodata.de Subject: Re: DBD::Oracle: table_info, PUBLIC schema X-Mailer: YahooMailClassic/11.4.20

(Fwd) Re: DBD::Oracle: table_info, PUBLIC schema

- Forwarded message from Satish Patil - Date: Mon, 21 Mar 2011 07:37:45 -0700 (PDT) From: Satish Patil To: tim.bu...@pobox.com, s.goeld...@eurodata.de Subject: Re: DBD::Oracle: table_info, PUBLIC schema X-Mailer: YahooMailClassic/11.4.20 YahooMailWebService/0.8.109.295617 Hi Tim and

Re: DBD::Oracle 'make test' fails - ORA-24327: need explicit attach before authenticating a user

On Feb 9, 5:02 pm, joseph.ko...@gmail.com (Joseph Koral) wrote: > However I came across this thread because I'm getting the same error > when I attempt to connect while running under mod_perl.  The same code > (simple test connection) runs fine from a standalone perl script, but > I get "ORA-24327

Re: DBD::Oracle 'make test' fails - ORA-24327: need explicit attach before authenticating a user

On Feb 1, 10:58 am, as...@msn.com (Alexander Saip) wrote: > I am trying to install DBD::Oracle 1.27 on Red Hat Enterprise Linux Server > release 5.5 (Tikanga), Linux 2.6.18-194.17.1.el5 x86_64 x86_64 x86_64 > GNU/Linux. > I have already deployed the latest Oracle InstantClient and can connect to

  1   2   3   4   5   6   7   8   9   10   >