library private mapping disabled
---end of output
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2008 8:59 PM
To: Capacio, Paula J; dbi-users@perl.org
Subject: RE: Memory fault(coredump) with two DBD type connections
check
all the libraries
Hello,
I am running Perl 5.8.8 with DBD-Oracle 1.19 compiled against Oracle
10.2 libs and DBD-DB2 1.0 compiled against DB2 8.1 libs. I can
successfully connect to Oracle databases via a Perl script. Similarly I
can successfully connect to DB2 databases via a Perl script. However,
when I try to
On March 28, Icheng said:
After I try the command you provide, I got the following error
Can't load
'/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl'
for module DBD::Oracle: No such file or directory at
/opt/perl5/lib/5.8.0/PA-RISC2.0/DynaLoader.pm line 229.
at test_dbd_ver.pl
On March 28, Fred Vachon said:
I have DBI and DBD::Oracle installed on a Solaris 10 machine.
When I run either of the 2 commands that were posted I error out with:
perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;'
Can't load
On February 19, 2008 12:22 PM, Jonathan Leffler
[EMAIL PROTECTED] wrote:
On Feb 19, 2008 10:04 AM, Capacio, Paula J [EMAIL PROTECTED] wrote:
I am getting the following error from make
ld: Unrecognized argument:
-Wl,+b/usr/oracle/client/10.2/lib:/usr/oracle/client/10.2/rdbms/lib
Fatal error
Hello,
I am getting the following error from make (excerpt only full list
follows)
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
/usr/bin/ld
-Wl,+b/usr/oracle/client/10.2/lib:/usr/oracle/client/10.2/r
dbms/lib -b
On Saturday, January 19, 2008 2:54 PM
gokul nath [mailto:[EMAIL PROTECTED] wrote:
To: Capacio, Paula J
hello sir
i need u r help. i have installed perl 5.8.8 in my windows box.
oracle 10g XE
DBI 1.5
i tried to install DBD-Oracle-1.18 , when i execute nmake file ,
following error
-Original Message-
From: Susantio, Herman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 25, 2007 9:03 PM
To: 'dbi-users@perl.org'
Subject: Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation
we just installed DBD Oracle 1.19 on Linux suse.
oracle 10.1.0.3 full version has
-Original Message-
From: Craig Metzer [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 5:36 PM
I'm getting an error trying to run an insert action due to the DATE
or DATETIME datatype. I couldn't find anything on it, and was
wondering
if anyone could point me in the right
Hello,
I built DBD-Oracle for version 10 using a /usr/oracle/rdbms directory.
However, now the DBAs want me to build it against a /usr/oracle/client
directory instead. What is the best way to uninstall DBD-Oracle?
Do I delete each directory and file that was created by the 'make
install' or is
Update:
I had our unix server tech open an issue with HP on this since we
have a maintenance contract. I attempted to use gcc because the
perl version installed was compiled with gcc. HP will help if we
follow the instructions here:
not a unix admin or a dba and all help is appreciated!!
Thanks in advance,
Paula
- Originalnachricht -
Von: Capacio, Paula J
Gesendet: Mon, 5.3.2007 20:56
An: dbi-users@perl.org
Betreff: Problems building DBD-Oracle-1.16 on HP
Hello, I am attempting to build DBD-Oracle-1.16 on HP running
Hello, I am attempting to build DBD-Oracle-1.16 on HP running perl
5.8.0. The server has Oracle 10g installed and I can successfully
connect to a remote database using SQLPlus.
I have tried all the various incantations listed in the READMEs (perl
Makefile.PL -p, perl Makefile.PL -nob, and perl
From lurking around this mail list over the years,
I've seen numerous items relating to building
DBD-Oracle against a specific version of the Oracle
client software on *nix systems.
Example: if DBD-Oracle was built using version 9,
then the Oracle client is upgraded to 10g;
it is necessary
Adjusted from top post, which is frowned on, to bottom/intersperse
Jan 28th Conversation:
From: liooil
Response by: Paula
Hope this topic is not [EMAIL PROTECTED]
relevant. My Apologies if it's the case...
No, the right list is the DBI-Users list
Sorry if double posted: Got a delivery error on liooil's eaddr and
correcting
Adjusted from top post, which is frowned on, to bottom/intersperse
Jan 28th Conversation:
From: liooil
Response by: Paula
Hope this topic is not [EMAIL PROTECTED]
relevant. My Apologies if it's the case...
No, the
Capacio, Paula J wrote:
Hello, I'm hoping someone can explain why one of these connect
statements work and the other doesn't. The script sets environment
values as such: $ENV{ORACLE_HOME} = /usr/oracle/product/8.1.7_64;
$ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via
$ARGV[1]
my
Capacio, Paula J [mailto:[EMAIL PROTECTED] wrote:
The code now looks like:
my $dbh;
if ($method =~ /2/) { #this works
$dbh = DBI-connect('', scott/tiger, '', 'Oracle')
or die Connect failed: $DBI::errstr\n;
}else{ #this doesn't
printIt(Just prior to connect
Hello, I'm hoping someone can explain why one of these connect
statements work and the other doesn't.
The script sets environment values as such:
$ENV{ORACLE_HOME} = /usr/oracle/product/8.1.7_64;
$ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via
$ARGV[1]
my $dbh;
if ($method =~ /2/)
John wrote:
Can anyone see the error in the following code. It has to do with the
placeholder in the select statement. Substitution fails to occur at
the $sth1-execute... statement script dies at while (my
$rowref If I replace the placeholder with a literal it works as
expected.
Hello,
I have successfully executed SQL statements to a DB2 database from perl
5.8.2 using DBI V1.48 and DBD::DB2 V0.78 on AIX 5.2.2.0. I'm now testing
the error handling, and it is not working as I expect. For instance I
try to prepare a statement I know will fail but error handling using
'or'
-Original Message-
From: Sid Katz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 12:14 PM
I am converting oraperl statments to the new Perl-DBI format and do
not entirely understand the Perl-DBI syntax. I have included code
with the oraperl method and what I think is the
From: Ian Harisay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 12:43 PM
snip
My perl program appears to be stripping trailing spaces. I
dynamically build my sql statement with the following function.
I am using
Linux Fedora Core 3
perl 5.8.5
DBD::Oracle 1.16
DBI 1.40
Are there any caveats that I should look out for
regarding ActiveState Perl 5.8 and the latest DBI modules?
Get your DBI and DBD modules from:
http://ftp.esoftmatic.com/DBI/
Adjusted from top post, which is frowned on, to bottom/intersperse
Jan 28th Conversation:
From: liooil
Response by: Paula
Hope this topic is not [EMAIL PROTECTED]
relevant. My Apologies if it's the case...
No, the right list is the DBI-Users list
Sorry if double posted: Got a delivery error on liooil's eaddr and
correcting
Adjusted from top post, which is frowned on, to bottom/intersperse
Jan 28th Conversation:
From: liooil
Response by: Paula
Hope this topic is not [EMAIL PROTECTED]
relevant. My Apologies if it's the case...
No, the
Tim Bunce:
Can you remember what made you think they were?
Anybody else out there using them?
Rob Meyer:
I use them all over the place, too.
What made me think they were standard is p. 95 of the Feb. 2000 edition
of
the Cheetah book, which describes them in quite a bit of detail:
I've
The snippet below used to run, but now fails doing a prepare of 'select
count(*) from sysibm.systables'.
The only known difference is an upgrade from DB2 V7 to V8. The DBA
insists that plans have been bound as public so security should not be a
problem. Any idea what the problem could be or what
The snippet below used to run, but now fails doing a prepare of 'select
count(*) from sysibm.systables'.
The only known difference is an upgrade from DB2 V7 to V8. The DBA
insists that plans have been bound as public so security should not be a
problem. Any idea what the problem could be or what
Ignore this appeal for help. I convinced the DBA it REALLY is a
security problem!
The script runs for him.
Paula
Jeff Urlwin wrote:
Sent: Tuesday, December 30, 2003 5:04 PM
I've restructured a bit and am basing the directory structure upon the
perl
version, not the AS build number. 807 reports as 5.8.2, so
ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2
Contains all the 5.8.2 specific versions.
So the following
Paula wrote
I just installed ActivePerl 5.8.1.807 on a WinXP box.
I downloaded and installed DBI 1.37 and DBD-Oracle 1.13 from
ftp.esoftmatic.com without incurring any errors.
However, when attempting to run this code:
#code snippet
use DBI;
$dbh =
I just installed ActivePerl 5.8.1.807 on a WinXP box.
I downloaded and installed DBI 1.37 and DBD-Oracle 1.13 from
ftp.esoftmatic.com without incurring any errors.
However, when attempting to run this code:
#code snippet
use DBI;
$dbh = DBI-connect(dbi:Oracle:host=hxddba01;sid=mp3u, 'scott',
On my way home last night I realized I could strip out more of my script and answer
the question myself. I proved that a failed prepare does NOT close the db handle.
The problem was in how I was passing the db handle to my error subroutine.
I had coded...
my $mColsth = $dbConn-prepare(
Merrill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 9:26 AM
To: Capacio, Paula J
Subject: Re: RESOLVED: Does failed PREPARE close db handle?
Paula, the one thing I noticed about your error processing
subroutine - the one that you wanted to return 243(I think
Hello...it's late and I may very well be brain-dead...that aside...
Does a failed PREPARE close the db handle or am I doing something wrong? When a
prepare fails I want to exit with a return code of 243. I don't want to waste or tie
up resources, and I assume that I am still connected and
I wrote a script on an NT workstation using AS Perl 5.6.1, DBI 1.14, DBD-Oracle 1.06
and it works fine. It's supposed to run on an NT server and it fails there where the
version of perl is 5.005_02, PPM query shows that DBI and DBD are present but does not
give version information. I looked
Hello, we're having problems installing DBI on an HP/UX V11, Perl 5.6.0,
DBI 1.20. Can anyone lend insight into what is wrong?
Output is as follows:
TIA
Paula
[/var/tmp/perl/DBI-1.20] # make
/opt/aCC/bin/aCC -c -Ae -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O +Onolimit
PSCI_1I am relatively new to Perl, primary experience through Windows NT
with limited knowledge of UNIX. I have been instructed to identify a
corporate standard version of Perl and upgrade our desktops and servers. For
servers we have NT, HP/UX and SunSolaris. We run Oracle 7 8, and DB2 UDB.
39 matches
Mail list logo
