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
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
It is mostly very quiet. I'm not sure who maintains DBD::Oracle these days.
Jonathan Leffler #include
Guardian of DBD::Informix - v2018.1031 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
On Wed, Nov 6, 2024 at 16:23
Bueller... Bueller...
Seriously, is this project even maintained anymore?
Rob
--- Forwarded Message ---
From: Rob DBA via dbi-users
Date: On Friday, November 1st, 2024 at 3:27 PM
Subject: DBD::Oracle OS authentication broken following Oracle 19.25 upgrade
To: dbi-users@perl.org
>
Hey all - New to the list, but not new to Oracle or DBD::Oracle. I opened an
issue yesterday (https://github.com/perl5-dbi/DBD-Oracle/issues/180) and today,
I built the latest Perl, DBI, and DBD::Oracle and replicated the issue. Before
adding all that noise to the github issue, I'm curi
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
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-
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
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
> 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
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
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 "sessi
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
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::
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
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
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
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
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
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 upgra
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
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
ora 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
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
&#
y environment is as below:
Linux RHEL 7.4
Oracle 12.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
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
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
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
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
/db/app/oracle/product/12.1.0/client_1/lib/libclnts
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
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
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...
>
7;1268251' 'aa' '1' undef 'en_US'
) [6 items] row858 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_f
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'
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 ,
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
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
Good question - I have asked DBA and am waiting for a reply.
-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, December 18, 2017 11:36 AM
To: Fennell, Brian ; dbi-users@perl.org
Subject: 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 rera
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
, 5
) d
WHERE
d.row_number < 202
AND d.row_number >= 100
-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, December 18, 2017 9:21 AM
To: Fennell, Brian ; dbi-users@perl.org
Subject: RE: Hunting down (possible) memory leak in DBD:
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
ht 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 o
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&#x
: Wednesday, August 17, 2016 4:25 AM
To: dbi-users@perl.org
Cc: LAWS, MICHAEL H
Subject: (Fwd) DBD::Oracle quote_identifier
- Forwarded message from "LAWS, MICHAEL H" -
Date: Tue, 16 Aug 2016 21:04:20 +
From: "LAWS, MICHAEL H"
To: "t...@cpan.org"
Subject
- Forwarded message from "LAWS, MICHAEL H" -
Date: Tue, 16 Aug 2016 21:04:20 +
From: "LAWS, MICHAEL H"
To: "t...@cpan.org"
Subject: DBD::Oracle quote_identifier
Hello,
I was using quote_identifier for table names on an oracle databas
In message , "Tony
D'Alfonso" writes:
>Does it still make a difference running it as 32-bit on a 64-bit machine. I`v
>e strictly been trying it on 64 bit.
What does file(1) report about the architecture of your Oracle.so?
# file /root/perl5/lib/perl5/x86_64-linux-thread-
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:
.
-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 wrote:
>
> SDK was installed t
read-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
> 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
> 10.2.0.3
On Jun 22, 2016, at 1:34 PM, John R Pierce
mailto:pie...@hogranch.com>> 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 affects is keeping track
...@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
> wrote:
>
> Hi Carl,
>
> I used CPAN to install them and it appeared as though they are in
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 t
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 DBD::Oracle
>
It means you don¹t have the Oracle DBD installed. Or its installed to a
different place.
Did you install it? Where?
Carl Yamamoto-Furst
--
From: Tony D'Alfonso
Date: Wednesday, June 22, 2016 at 2:00 PM
To: "dbi-users@perl.org"
Subject: RE: Bundle::DBI and DBD:
et::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 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 u
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: libstdc++.so.5: c
# 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 17:01
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
mod
On 2/7/2016 3:12 AM, Martin J. Evans wrote:
You need to install a C compiler - the one your Perl was built with is
most likely to work.
the perl that comes with solaris is built with Oracle Studio C (formerly
Sun Forte C) ...
but I seem to recall there was a solaris perl make script that worke
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+p
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+not+installed
Tim.
On Fri, Feb 0
> 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 R
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
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
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 ol
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 i
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
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.
>
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
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.
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
!!!
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, at
) Issue :DBD::Oracle installation
- Forwarded message from Ranjitha -
Date: Wed, 4 Jun 2014 11:05:34 +
From: Ranjitha
To: "tim.bu...@pobox.com" , "t...@cpan.org"
Subject: Issue :DBD::Oracle installation
Hi Tim
Facing an issue while installing DBD::Orac
asn't 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
On 04/06/14 12:44, tim.bu...@pobox.com wrote:
- Forwarded message from Ranjitha -
Date: Wed, 4 Jun 2014 11:05:34 +
From: Ranjitha
To: "tim.bu...@pobox.com" , "t...@cpan.org"
Subject: Issue :DBD::Oracle installation
Hi Tim
Facing an issue while in
- Forwarded message from Ranjitha -
Date: Wed, 4 Jun 2014 11:05:34 +
From: Ranjitha
To: "tim.bu...@pobox.com" , "t...@cpan.org"
Subject: Issue :DBD::Oracle installation
Hi Tim
Facing an issue while installing DBD::Oracle module from CPAN.
Direct in
Mail: 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 modu
Mail: 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 fai
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-
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
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("NA
# 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. Ra
fetch result
> print "$row\n";
> $row = $s->fetch; # 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
In message
, 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", "tiger",
{ RaiseError => 1 } );
my $sth =
sysoft.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
ike but I doupt that is it.
> Date: Wed, 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->ex
y ($row) = $s->fetchrow_array;
print "$row\n";
$row = $s->fetch;
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
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 err
change it again to
>>if ($price_sth->{Active} 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 message
, 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__, __LINE__);
>}
>
>
>I expected the fetch to return unde
$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 i
ubject: 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 runni
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
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
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
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 lo
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
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/buil
1 - 100 of 3944 matches
Mail list logo
