::Oracle)
Hi,
Our (standalone) Perl scripts often encounter memory corruptions after a
migration on RHEL5.5 (Perl 5.8.8) with Oracle
client 11.1.0 and DBD-Oracle-1.26.
Some Oracle core dumps are present in the Oracle client directory
../incident/incdir_... with the generic error code
oci-24550.
We had
this may be an 11g issue and not a perl/DBI/DBD issuse
Have you applied all the patches for 11to the 11g DB??
Cheers
John Scoles
Date: Fri, 19 Nov 2010 18:06:21 +0100
From: li...@alixen.fr
To: dbi-users@perl.org
Subject: Memory corruption with Perl (DBD::Oracle)
Hi,
Our (standalone) Perl scripts
Seems this may be an 11g issue and not a perl/DBI/DBD issuse
Have you applied all the patches for 11to the 11g DB??
Cheers
John Scoles
Date: Fri, 19 Nov 2010 18:06:21 +0100
From: li...@alixen.fr
To: dbi-users@perl.org
Subject: Memory corruption with Perl (DBD::Oracle)
Hi,
Our
Hi,
Our (standalone) Perl scripts often encounter memory corruptions after a migration on RHEL5.5 (Perl 5.8.8) with Oracle
client 11.1.0 and DBD-Oracle-1.26.
Some Oracle core dumps are present in the Oracle client directory ../incident/incdir_... with the generic error code
oci-24550.
We had
, even though the data in $txt looks correct, perl thinks the
internal length of the variable is whatever it was after fetching the first
row. This screws up things like sprintf.
I'm pretty sure this behaviour is a DBD::Oracle thing rather than a DBI
thing. I tried an equivalent script with DBD
.plx
[1][AA] len=2
[2][BBB] len=2
[3][] len=2
As you can see, even though the data in $txt looks correct, perl thinks the
internal length of the variable is whatever it was after fetching the first
row. This screws up things like sprintf.
I'm pretty sure this behaviour is a DBD::Oracle thing
On 18/11/2010 3:15 PM, Steve Baldwin wrote:
Ok one more to look at for DBD::Oracle 1.28
Hi,
I ran across an issue recently that appears to have existed for quite some
time.
Consider the following script ...
#!/usr/bin/perl -w
use strict;
use warnings;
use DBI;
sub main {
my $dbh = DBI
On 04/11/10 15:37, John Scoles wrote:
You can find Release Candidate 1 for DBD::Oracle 1.27 here
http://svn.perl.org/modules/dbd-oracle/branches/polute/DBD_ORACLE_1_27_RC_1.tar.zip
This release is limited to cleaning up Perl globals within the C and XS code.
Short version
PERL_POLLUTE
On 11/5/2010 5:22 AM, Martin J. Evans wrote:
On 04/11/10 15:37, John Scoles wrote:
You can find Release Candidate 1 for DBD::Oracle 1.27 here
http://svn.perl.org/modules/dbd-oracle/branches/polute/DBD_ORACLE_1_27_RC_1.tar.zip
This release is limited to cleaning up Perl globals within the C
You can find Release Candidate 1 for DBD::Oracle 1.27 here
http://svn.perl.org/modules/dbd-oracle/branches/polute/DBD_ORACLE_1_27_RC_1.tar.zip
This release is limited to cleaning up Perl globals within the C and XS
code.
Short version
PERL_POLLUTE is being dropped from perl 5.13.3 so
On 10/29/2010 1:13 PM, Alexander Saip wrote:
Might be a strawberry perl thing??
Can you give it a try with Activestate perl or with and eariler
DBD::Oracle 1.24 or 1.23 or the 10 instant client??
Cheers
John Scoles
Sorry for the delayed response. I had to make Oracle connection work
ASAP
that folder in
its list. What else may cause those errors?
Date: Thu, 28 Oct 2010 13:03:52 -0400
From: sco...@pythian.com
To: as...@msn.com
CC: dbi-users@perl.org
Subject: Re: undefined references when installing DBD::Oracle on Windows Server
2008
On 10/28/2010 12:18 PM, Alexander Saip wrote:
John
On 10/29/2010 3:25 PM, Alexander Saip wrote:
Ok that sounds like it I will have to fix that if it is in the present
release?
Thanks for pointing that out.
Cheers
John Scoles
I guess not... I eventually managed to build, test and install
DBD::Oracle. The culprit turned out to be oci.def file
On 10/29/2010 3:51 PM, John Scoles wrote:
On 10/29/2010 3:25 PM, Alexander Saip wrote:
Ok that sounds like it I will have to fix that if it is in the present
release?
Thanks for pointing that out.
Cheers
John Scoles
I guess not... I eventually managed to build, test and install
DBD::Oracle
I guess not... I eventually managed to build, test and install DBD::Oracle. The
culprit turned out to be oci.def file in the CPAN folder. After I edited it by
adding all those undefined references, everything worked like a charm. Quick
note: I switched to the 32-bit versions of Perl and Oracle
Hi Everybody,
Usually, I am able to figure out or find answers to DBD::Oracle installation
problems, but not this timeā¦ I am trying to get the module installed on Windows
Server 2008 R2 Enterprise (64-bit) running Strawberry Perl, as follows:
Summary of my perl5 (revision 5 version 12
On 10/28/2010 10:23 AM, Alexander Saip wrote:
Hi Everybody,
Windows Server 2008 R2 Enterprise (64-bit) running Strawberry Perl, as follows:
Strawberry Perl
never did DBD::Oracle to like it.
myself had you installed it before on a box with Strawberry??
Oracle.o:Oracle.c:(.text+0x34a2
On 10/28/2010 12:18 PM, Alexander Saip wrote:
John,
thanks for your comments. I have successfully installed DBD::Oracle on
a Windows 7 (64-bit) box, but used both 32-bit Strawberry Perl and
Oracle instant client. That may be the way for me to go, unless I can
make the 64-bit stuff work
Hi. First post here.
We have the Oracle instant client 10.0.2.0 installed and working fine on our
s390x (aka s390 64-bit, zLinux) host. Now we want to use DBD::Oracle there, but
I can't find any precompiled packages anywhere, and when we try to build it we
get either
The ORACLE_HOME
On 27/10/10 09:43, Andrew Schulman wrote:
Hi. First post here.
We have the Oracle instant client 10.0.2.0 installed and working fine
on our s390x (aka s390 64-bit, zLinux) host. Now we want to use
DBD::Oracle there, but I can't find any precompiled packages
anywhere, and when we try
We have the Oracle instant client 10.0.2.0 installed and working fine
on our s390x (aka s390 64-bit, zLinux) host. Now we want to use
DBD::Oracle there, but I can't find any precompiled packages
anywhere, and when we try to build it we get either
The ORACLE_HOME environment variable
cheers
John Scoles
Thanks, I've been fortunate enough in my dealings with DBD or DBI that I
haven't had to run prove at this point..
The output from prove -vb t/31lob.t follows:
DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an
unsupporte.
# Failed test 'returned length via
When I do make test on DBD::Oracle-1.26 with Oracle 11gR2 on Ubuntu
10:04 x64 it fails t/31lob.t test 9. Is this a known problem or am I
doing something wrong.
My perl info:
$ perl -V
Summary of my perl5 (revision 5 version 10 subversion 1) configuration:
Platform:
osname=linux, osvers
it down
cheers
John Scoles
When I do make test on DBD::Oracle-1.26 with Oracle 11gR2 on Ubuntu
10:04 x64 it fails t/31lob.t test 9. Is this a known problem or am I
doing something wrong.
My perl info:
$ perl -V
Summary of my perl5 (revision 5 version 10 subversion 1) configuration:
Platform
, October 19, 2010 12:03 PM
To: CAMPBELL, ED (ATTBST)
Cc: dbi-users@perl.org
Subject: Re: DBD::Oracle-1.26 fails test t/31lob.t on Oracle 11gR2
Ubuntu 10.04
On 10/19/2010 10:34 AM, CAMPBELL, ED (ATTBST) wrote:
No I do not think you buggered anything up.
Might be a permissions error or alike
your test exited with 2 before it could output anything.
t/31lob.t ..
Dubious, test returned 2 (wstat 512, 0x200)
Failed 12/12 subtests
You need prove -vb t/32lob.t if you run it from the untarred DBD::Oracle
distribution else you are attempting to run it using the installed
DBD::Oracle which
On 13/10/10 02:25, Carlson, John W. wrote:
What is the recommended DBD::Oracle version and which instant client
should I compile against for Oracle 11g databases, RedHat el5xen
Linux x86_64 (64bit) architecture? There appears to be several
recent oddly named versions on CPAN. 1.26 is out
On 10/13/2010 4:12 AM, Martin J. Evans wrote:
On 13/10/10 02:25, Carlson, John W. wrote:
What is the recommended DBD::Oracle version and which instant client
should I compile against for Oracle 11g databases, RedHat el5xen
Linux x86_64 (64bit) architecture? There appears to be several
recent
What is the recommended DBD::Oracle version and which instant client should I
compile against for Oracle 11g databases, RedHat el5xen Linux x86_64 (64bit)
architecture? There appears to be several recent oddly named versions on CPAN.
1.26 is out there, but it doesn't appear to be the latest
On 05/10/2010 17:44, Scott T. Hildreth wrote:
On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote:
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Eric,
Are you compiling a linux Perl? It won't work with out it. I have
the port emulators
On 03/10/10 17:45, Eric Yellin wrote:
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Here is what I have done so far:
1. Installed the 3 Oracle Instant Client ports:
- linux-oracle-instantclient-basic
- linux-oracle-instantclient-sdk
On 10/5/2010 3:58 AM, Martin J. Evans wrote:
On 03/10/10 17:45, Eric Yellin wrote:
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Here is what I have done so far:
1. Installed the 3 Oracle Instant Client ports:
- linux-oracle-instantclient-basic
On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote:
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Eric,
Are you compiling a linux Perl? It won't work with out it. I have
the port emulators/linux_dist-gentoo-stage3 installed
On 10/3/2010 12:45 PM, Eric Yellin wrote:
I have yet to try an build DBD::Oracle for FreeBSD so the Makefile might
not be working correctly here are my comments
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Here is what I have done so far:
1
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Here is what I have done so far:
1. Installed the 3 Oracle Instant Client ports:
- linux-oracle-instantclient-basic
- linux-oracle-instantclient-sdk
- linux-oracle-instantclient-sqlplus
These install
I am using the new DBD::Oracle module with DRCP. I am able to connect
to my connection pool, but the NUM_HITS does not increment, and the
connection class is always SHARED instead of whatever I specify
(using either the environment variable or the connection parameter)
What am I doing wrong?
I
/docs/cd/B28359_01/server.111/b28320/dynviews_1082.htm)
NUM_HITS - Total number of times a session that matches with the
request was found in the pool. Basically, it never finds a match.
Connection Class is synonymous with ora_drcp_class.
Something that is not clear to me - does DBD::Oracle 1.25
On 9/14/2010 12:41 AM, John R Pierce wrote:
On 05/18/10 9:41 AM, Charles Jardine wrote:
On 17/05/10 23:05, John R Pierce wrote:
I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM
AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL
C v11.1 + the latest
On 09/14/10 5:35 AM, John Scoles wrote:
Did this ever get tested and entered into the DBD-Oracle release ?
This issue has surfaced at work, so I can probably try testing your
patches some time in the next week or so, possibly on both sparc and
aix/power platforms, but if someone else has
On 9/14/2010 9:17 AM, John R Pierce wrote:
On 09/14/10 5:35 AM, John Scoles wrote:
Did this ever get tested and entered into the DBD-Oracle release ?
This issue has surfaced at work, so I can probably try testing your
patches some time in the next week or so, possibly on both sparc and
aix
On 09/14/10 6:58 AM, John Scoles wrote:
On 9/14/2010 9:17 AM, John R Pierce wrote:
Sorry, I meant, the make test problems with t/58object on big endian
machines like Sparc, IBM Power
Ok that clears it up a little.
I am not sure if it was fixed yet.
Give the latest trunk version a try
. Evans; dbi-users@perl.org
Subject: Re: DBD Oracle connectivity
Hi,
I have installed oracle 10g client on my system. But still i am getting
error while trying to connect to oracle as follows:
DBI connect('host=10.7.85.32;sid=SMDB1;port=1521','wb',...) failed: ERROR
OCINls
EnvironmentVariableGet
On 07/25/2010 09:42 PM, Vinod Guleria wrote:
Hi,
I have installed oracle 10g client on my system. But still i am getting
error while trying to connect to oracle as follows:
DBI connect('host=10.7.85.32;sid=SMDB1;port=1521','wb',...) failed: ERROR
OCINls
Hi,
I have installed oracle 10g client on my system. But still i am getting
error while trying to connect to oracle as follows:
DBI connect('host=10.7.85.32;sid=SMDB1;port=1521','wb',...) failed: ERROR
OCINls
EnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS
settings et
c. at
No, even with DBD::ODBC you need an Oracle client, not for DBD::ODBC
itself, but the ODBC manager needs one. Windows comes out of the box
with a prehistoric Oracle client that causes more trouble than it is
worth, so even there, you want to install a RECENT Oracle client.
The only way to
Alexander Foken wrote:
No, even with DBD::ODBC you need an Oracle client, not for DBD::ODBC
itself, but the ODBC manager needs one. Windows comes out of the box
with a prehistoric Oracle client that causes more trouble than it is
worth, so even there, you want to install a RECENT Oracle
the perl Makefile.pl without significant problems.
However the make itself brings an error you can see below.
[/tmp/dbd]$ make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle
I guess you could use DBD::ODBC that does net require an oracle client.
cheers
John Scoles
On Fri, Jul 16, 2010 at 4:50 AM, Martin J. Evans
martin.ev...@easysoft.comwrote:
Vinod Guleria wrote:
Dears,
Could you pls let me know that Is there a way to connect to oracle DB(on
remote
Dears,
Could you pls let me know that Is there a way to connect to oracle DB(on
remote system) without having oracle client on my system.
Thanks Regards,
Vinod Guleria.
Vinod Guleria wrote:
Dears,
Could you pls let me know that Is there a way to connect to oracle DB(on
remote system) without having oracle client on my system.
Thanks Regards,
Vinod Guleria.
If you are absolutely sure you cannot install any Oracle software on
your machine you need
John Scoles
On Thu, Jul 1, 2010 at 2:05 AM, Shibi NS shibi...@gmail.com wrote:
I am getting following error
while using DBB::Oracle
httpd: symbol lookup error: /nfs/private/user/sns/tech-stack/
10.06.28.03/linux/lib/perl5/site_perl/5.8.8/i686-linux-64int/auto/DBD/Oracle/Oracle.so:
undefined
On 07/14/2010 03:34 AM, John Scoles wrote:
--gone--
httpd: symbol lookup error: /nfs/private/user/sns/tech-stack/
10.06.28.03/linux/lib/perl5/site_perl/5.8.8/i686-linux-64int/auto/DBD/Oracle/Oracle.so:
undefined symbol: ora_sql_error
httpd: symbol lookup error: /nfs/private/user/sns/tech
Unless you are going to use an oracle embeded type (table, Object, Varray) I
would not worry about this error.
I think I applied that patch to the Trunk of DBD::ORacle a while back.
give the code here a try to see if it fixes the error
http://svn.perl.org/modules/dbd-oracle/trunk
Hallo,
while executing a make test with DBD-Oracle 1.24b I got an error on my HP
box.
I think, that the same problem was reported in the thread DBD-Oracle 1.24a
reports ORA-24334 in t/58object.t
by Timothy Everett on his SUN machine.
There is mentioned, that the problem was solved by a patch
...@symantec.com wrote in message
news:4c110b04.60...@symantec.com...
On 06/09/2010 08:43 AM, Benjamin Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is
running
well.
Everytime I wan't
test
9) should still fail with a different error
10) set the TNS_HOME
11) rerun the make test
12) should conenct
My last gasp at it.
Cheers
John
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Date: Fri, 25 Jun 2010 16:06:32 +0800
From: pbk...@motorola.com
To: sco...@pythian.com
Don't know what else to say.
You either have a bad perl or DBI/DBD install or something on the network
permission side is blocking you.
Can't really help more than that.
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Date: Mon, 28 Jun 2010 19:06:23 +0800
From: pbk
produkt bedzie mial takie pola (poki co)
wyszukiwanie po nazwie,producencie,statusie
product_name
product_description
product_producer
product_status_id
product_price
product_price_currency_id
product_price_datetime
product_created_datetime
product_modified_datetime
product_url
sorry, my mistake :(
Hi all,
My Oracle database NLS language is AMERICAN English.
In DBD::Oracle, what variable/value should I set?
Thanks.
Yeow
-Original Message-
From: Yeow Yiew Choong-PBKN64
Sent: Thursday, June 24, 2010 11:00 AM
To: 'John Scoles'
Cc: dbi-users@perl.org
Subject: RE: Perl 5.8.9 DBI/DBD
Hi all,
Tried TNS_ADMIN =/opt/instantclient_10_2/ and
ORACLE_USERID=scott/ti...@zmy12sora02 but still same error.
I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different
settings combination for TNS_ADMIN and ORACLE_USERID but still not
successful.
I am wondering what DBD::Oracle
Well not havening much luck are we.
At this point I think you either have a bad Perl, DBI or DBD::Oracle
installation and or a you have multiple installations of DBI and
DBD::Oracle.
So to see what you DBI can see give this a try
use DBI;
print available_drivers:\n;
print $_\n foreach DBI
this thread may help as well
http://forums.oracle.com/forums/thread.jspa?threadID=872112
Hi all,
My Oracle database NLS language is AMERICAN English.
In DBD::Oracle, what variable/value should I set?
Thanks.
Yeow
-Original Message-
From: Yeow Yiew Choong-PBKN64
Sent: Thursday, June 24
On 06/24/2010 05:52 AM, John Scoles wrote:
Well not havening much luck are we.
At this point I think you either have a bad Perl, DBI or DBD::Oracle
installation and or a you have multiple installations of DBI and
DBD::Oracle.
---deleted on purpose ;)
Perhaps it might help to start
test, it cannot connect. Why?
Thanks.
Yeow
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Tuesday, June 22, 2010 6:44 PM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
How are you connecting with SQLPLus
Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
How are you connecting with SQLPLus?
Still failed with TNS_ADMIN configured exported.
I tried another user with dba role but same error.
sqlplus can connect but DBD::Oracle cannot, how
How are you connecting with SQLPLus?
Still failed with TNS_ADMIN configured exported.
I tried another user with dba role but same error.
sqlplus can connect but DBD::Oracle cannot, how to troubleshoot what
is preventing it to connect?
Thanks.
Yeow
Hi,
Still failed with TNS_ADMIN configured exported.
I tried another user with dba role but same error.
sqlplus can connect but DBD::Oracle cannot, how to troubleshoot what is
preventing it to connect?
Thanks.
Yeow
From: John Scoles [mailto:sco...@pythian.com
...@pythian.com]
Sent: Friday, June 18, 2010 12:04 AM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Yeow Yiew Choong-PBKN64 wrote:
I really doubt there is a scott/tiger user on you Oracle box
set the ORACLE_USERID to a value user
with make test DBD Oracle on RHEL5 server
Looks like the 64 bit client you are using is not all there. I would
give the instant client 64 a shot. Just to be sure get the SDK as well.
Cheers
John scoles
I am having a problem getting DBD-Oracle to work. It is failing on the make
test
/2010 08:43 AM, Benjamin Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is
running
well.
Everytime I wan't to install the package I got the message
I am having a problem getting DBD-Oracle to work. It is failing on the make
test on the initial test. If you could please give me any ideas you might have
on resolving this I would be so grateful. I have been trying to resolve this
for several days!!
Thanks in advance
[r
Hi,
I have HP-UX 11.11(64bit PA-RISC) and Perl 5.8.9.(32bit 64bit)
The Perl I installed from depot file from www.develooper.com. I am using
gcc 3.4.3 depot file from ftp.thewrittenword.com.
I am new to Perl. I want to install DBD::Oracle 1.24 (from CPAN) so that
I can connect to remote
Looks like the 64 bit client you are using is not all there. I would
give the instant client 64 a shot. Just to be sure get the SDK as well.
Cheers
John scoles
I am having a problem getting DBD-Oracle to work. It is failing on the make
test on the initial test. If you could please give me
5.8.9.(32bit 64bit)
The Perl I installed from depot file from www.develooper.com. I am using
gcc 3.4.3 depot file from ftp.thewrittenword.com.
I am new to Perl. I want to install DBD::Oracle 1.24 (from CPAN) so that
I can connect to remote database Oracle 10g.
I am using Oracle Instantclient
Forgot to cc this reply to the list
-Original Message-
From: CAMPBELL, ED (ATTBST)
Sent: Thursday, June 17, 2010 12:52 PM
To: 'John Scoles'
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
The scott/tiger user in Oracle is Locked with an expired password by
default, so you need
Bob McGowan bob_mcgo...@symantec.com wrote in message
news:4c110b04.60...@symantec.com...
On 06/09/2010 08:43 AM, Benjamin Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is running
well
Hi,
I just wanted to know what is the compatible version of DBI and Oracle DBD for
perl, v5.6.1? It would be great if you can provide me with the information as
soon as possible since it's very urgent.
Thanks a lot for your time!
Regards,
Subhasis.
.
You need Perl 5.8.1 at least for the latest version of DBI (1.611). You
can see the platforms and versions tested at
http://matrix.cpantesters.org/?dist=DBI+1.611.
You need Perl 5.3 at least for the latest version of DBD::Oracle (1.24)
- also see http://matrix.cpantesters.org/?dist=DBD-Oracle
,
Subhasis.
You need Perl 5.8.1 at least for the latest version of DBI (1.611). You
can see the platforms and versions tested at
http://matrix.cpantesters.org/?dist=DBI+1.611.
You need Perl 5.3 at least for the latest version of DBD::Oracle (1.24)
- also see http://matrix.cpantesters.org
Benjamin Mark wrote:
Bob McGowan bob_mcgo...@symantec.com wrote in message
news:4c110b04.60...@symantec.com...
On 06/09/2010 08:43 AM, Benjamin Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which
On 06/16/2010 05:14 AM, Martin Evans wrote:
Benjamin Mark wrote:
Bob McGowan bob_mcgo...@symantec.com wrote in message
news:4c110b04.60...@symantec.com...
On 06/09/2010 08:43 AM, Benjamin Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed
to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is running
well.
Everytime I wan't to install the package I got the message:
#
Removing previously used /home
Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is
running
well.
Everytime I wan't to install the package I got the message
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is running
well.
Everytime I wan't to install the package I got the message:
#
Removing
From: Yeow Yiew Choong-PBKN64
Sent: Saturday, June 05, 2010 6:00 PM
To: 'John Scoles'
Cc: John Scoles; dbi-users@perl.org
Subject: RE: Make Test Failed For DBD-Oracle 1.24
Hi John,
Please refer the output error below:
# perl Makefile.PL -lcl
Using DBI 1.611
On 06/09/2010 08:43 AM, Benjamin Mark wrote:
Hello,
I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
I've installed a Oracle 10gR2 database (not the client) which is running
well.
Everytime I wan't to install the package I got the message
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, June 04, 2010 8:05 PM
To: Yeow Yiew Choong-PBKN64
Cc: John Scoles; dbi-users@perl.org
Subject: Re: Make Test Failed For DBD-Oracle 1.24
give
perl Makefile.PL -lcl
a try and make again
-RISC1.1-thread-multi) installed
in /opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008003 on hpux
(PA-RISC1.1-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Installing on a hpux, Ver#11.00
Using
to upgrade my perl to 64bit version?
How?
Thanks.
regards,
YC
From: John Scoles [mailto:byter...@hotmail.com]
Sent: Wednesday, June 02, 2010 8:41 PM
To: Yeow Yiew Choong-PBKN64; dbi-users@perl.org
Subject: RE: Make Test Failed For DBD-Oracle 1.24
Never ran
Test Failed For DBD-Oracle 1.24
If that is the case then use the 32bit instant client, (you can get that
for free from Oracle)
and compile against that.
Subject: RE: Make Test Failed For DBD-Oracle 1.24
Date: Thu, 3 Jun 2010 17:42:16 +0800
From: pbk
test.
Thanks.
regards,
YC
From: John Scoles [mailto:byter...@hotmail.com]
Sent: Thursday, June 03, 2010 7:12 PM
To: Yeow Yiew Choong-PBKN64; dbi-users@perl.org
Subject: RE: Make Test Failed For DBD-Oracle 1.24
If that is the case then use the 32bit
/DBI-1.611/DBI.pm#execute_array method.
and it is available to all DBD drivers.
DBD::Oracle is special as it implements its own version of it that takes
advantage of Oracle's array interface. It has been in there since 1.18.
here is an example of its use
my @in_values=('1',2,'3','4',5,'6',7,'8
If that is the case then use the 32bit instant client, (you can get that for
free from Oracle)
and compile against that.
Subject: RE: Make Test Failed For DBD-Oracle 1.24
Date: Thu, 3 Jun 2010 17:42:16 +0800
From: pbk...@motorola.com
To: byter...@hotmail.com; dbi-users@perl.org
Hi
Hi,
I have problem when I run make test for DBD::Oracle 1.24 module.
My Oracle database is on remote server.
Oracle database version is 10g, and my Oracle client is version 10.2
(64bit) on HP-UX 11.11(PA-RISC) 64bit OS.
I can run splplus to connect to remote database.
My perl is version 5.8.3
Hi!
Since I came into this topic while writing a script: What does
DBD::Oracle know about bulk operations?
In PL/SQL you can speed up your cursor loops by using bulk fetches
and/or bulk updates/inserts. Instead of operating on single rows you use
arrays of rows. Since DBI does not support
Johannes Gritsch wrote:
DBI does support bulk operations and what you are asking about is the
array interface.
It does it though the 'execute_array'
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#execute_array method.
and it is available to all DBD drivers.
DBD::Oracle is special
Never ran into that myself but this link looks like the same error
http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1272030523151+28353475threadId=1078200
cheers
John
Subject: Make Test Failed For DBD-Oracle 1.24
Date: Tue, 1 Jun 2010 19:04:44 +0800
From
Hi, all
I am using DBD::Oracle 1.23 on an Ubuntu Server 8.04 64 bit system,
against latest Instant Client:
Client Shared Library 64-bit - 11.2.0.1.0
System name:Linux
Release:2.6.9-78.0.0.0.1.ELxenU
Version:#1 SMP Fri Jul 25 16:25:38 EDT 2008
Machine:x86_64
I'm getting an error when I try to use a left outer join in my Perl program.
I have not found anything about joins in the documentation of the DBD:Oracle
module.
I'm using DBD::Oracle v1.18 on Perl v5.8.5 to connect to our Oracle 10.02.0400
dB.
If it should work, I will continue to work
301 - 400 of 3490 matches
Mail list logo