I have Red Hat 7.2
I already Install DBI, DBD::Pg
but I get this error
Can't locate loadable object for module DBI in INC (INC contains:
/usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1
Is there anyway to build DBD so that it can be used with either various
version of Oralce 8 and Oracle 9i.
Thanks
AG
Your DBI have error in line 223.
check it, may be permition problem..
On 17 Apr 2002 21:08:07 -0500
Aguztyn Garcia-Cruz [EMAIL PROTECTED] wrote:
I have Red Hat 7.2
I already Install DBI, DBD::Pg
but I get this error
Can't locate loadable object for module DBI in @INC (@INC contains:
hi all,
two years ago, I failed to rewrite a c interbase database upload program
in perl because by then, it was impossible to create blob fields with
DBD::Interbase.
Since then, I haven't been following the progress in this field. Can
anybody tell me if this module contains blob upload
If I build DBD against 8.x I have no problem, but if I then change the
environment to Oracle 9i, Perl fails because it cannot find the Oracle 8
libraries.
Is there a way to build DBD so that it dynamically looks for the oracle
version?? and then uses the relevant libraries
- Original
Hello,
I use DBD::ODBC and DirectTechnologies ODBC Client driver for connecting
a MS SQL SERVER 2000.
w/ DBD::ODBC 0.39 I haven't got any problems but w/ 0.41 I run into
trouble, after setting:
$dbh-{odbc_default_bind_type} = 1;
everything is fine.
Why has the default value changed in
Hi.
I use DBD:ODBC with MS SQL Database.
SQL statement is: 'select a, b, c from mytable compute sum(a), sum(b)'.
This statement returns two recordsets. When I use 'fetchrow_arrayref',
it returns only first recordset. How can I retrieve second?
Thanks.
Vasily Popov.
the tns entry is not a problem... however, that could lead to other problems
with our development enviroment. the only solution that i have at the
moment would be to have two perls, one for 8 and one for 9... however this
is not really ideal.
all oracle 8 versions are ok as most librarys are
Does anyone have a link of info on how to build DBD on HPUX 11i...
Thanks
On Thu, 18 Apr 2002 13:33:50 +0400
[EMAIL PROTECTED] wrote:
This statement returns two recordsets. When I use 'fetchrow_arrayref',
it returns only first recordset. How can I retrieve second?
Fetchrow fetches, well - as it names says, just one row.
Call it as many time, as many rows is
On Thu, 18 Apr 2002 12:12:03 +0200
Alex Green [EMAIL PROTECTED] wrote:
Does anyone have a link of info on how to build DBD on HPUX 11i...
You mean DBI, or some specific driver?
Instalation of DBI was quite easy, and went witout problems.
Waldemar
--
o Powiadam Wam, i straszny czas nasta na
While( $array_ref = $sth-fetchrow_arrayref() ) {
#recordset treatement here ...
}
José.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:34 AM
To: [EMAIL PROTECTED]
Subject: How to retrieve multiply recordsets returned by
'Morning,
Well, I changed my code to the following:
/^a_type/ do {
foreach $position (keys
$bighash-{a_type}) {
$cdr[$position] =~ s/\'/-/g;
$sth-bind_param($position + 1,
$cdr[$position],
Look in DBD::ODBC documentation: This clip is from one of the
DBD::ODBC tests 09multi.t
do {
# print join(:, {$sth-{NAME}}), \n;
while ( my $ref = $sth-fetch ) {
# print join(:, $ref), \n;
}
$result_sets++;
} while ( $sth-{odbc_more_results} ) ;
Use $dbh-trace(...) and study what it says.
Tim.
On Thu, Apr 18, 2002 at 08:38:59AM -0400, Chris Fuhrman wrote:
'Morning,
Well, I changed my code to the following:
/^a_type/ do {
foreach $position (keys
$bighash-{a_type}) {
I was able to install DBI, and DBD for MySQL under 11.0, and I will
be doing this under 11i. I am quite suprised that you are having trouble.
Please let us know of your results.
-Original Message-
From: Waldemar Zurowski [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002
Please for the past 2 weeks I have been trying to install DBI package on my Windows
2000 computer running perl 5.61.
When i use PPM to install I get this error Error Installing package 'dbi': Could not
locate a PPD file for package dbi
and When I use nmake I get this error NMAKE : fatal error
According to Ilya in one his reply :
Ilya wrote:
[BEGIN]
You need a Visual C++ compiler in order to compile any perl modules for ActiveState
perl, and it's utility is nmake not make. cl is the actual compiler.
You don't have to do it though as you can install binaries already precompiled.
I
Okay, I figured it out. A typo in another section of code was causing
another type to clobber the spaces in my strings. DOH!
Thanks for the help! Learned a few things correcting this problem
*smiles*
On Thu, 18 Apr 2002, Tim Bunce wrote:
Use $dbh-trace(...) and study what it says.
Did you install it under the same perl that you are running the script with?
If you have two or more perl installs on that machine, that might of been
the problem. Make sure you install and use the same one (ie, use full
path).
Ilya
-Original Message-
From: Aguztyn Garcia-Cruz
To:
Actually, the default bind type was 12 (SQL_VARCHAR) in versions .39 and
below.
If you read the POD documentation, you will see that setting it to 0 tells
DBD::ODBC to try to ask the driver itself which type should be for binding.
I believed that this would be an improvement for *most* users.
Read the DBD::ODBC pod regarding the attribute odbc_more_results and also
see t\09multi.t for examples.
Jeff
-Original Message-
From: ÷ÁÓÉÌÉÊ ðÏÐÏ× [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 5:34 AM
To: [EMAIL PROTECTED]
Subject: How to retrieve multiply recordsets
8.1.7 - client
8.1.7.1 - server
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Apr 18
10:19:37 2002
ezpnjdp3 make test 21 | tee /tmp/dbd_test.txt
PERL_DL_NONLAZY=1 /usr/users/u860323/bin/perl
-Iblib/arch -Iblib/lib
-I/usr/users/u860323/lib/perl5/5.6.1/alpha-dec_osf
Hi:
Now, i have problems for install DBD-Oracle-1.12, can help me?
Here is the LOG:
# perl Makefile.PL
Using DBI 1.20 installed in
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI
Configuring DBD::Oracle ...
Remember to actually *READ* the README file!
Especially if
You **must** have the Oracle client libs installed before you can compile
DBD::Oracle. You can get them from technet.oracle.com
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/18/02 9:15 AM
Subject: Error installing DBD
Hi:
Now, i have problems for
Do you use a http proxy? If so then you must set your http_proxy env
variable first. Read the pod on ppm.
--
Simon Oliver
- Original Message -
From: Chuks Anoshiri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 1:33 PM
Subject: Please help
Please for the
From: NYIMI Jose (BMB) [EMAIL PROTECTED]
To: Chuks Anoshiri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Sterin, Ilya [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 07:05
Subject: RE: Please help
Ilya wrote:
[BEGIN]
You need a Visual C++ compiler in order to compile any perl modules for
Hello,
thanks to Perl DBI I just wrote the first dataset with SQL to a Access
database after some problems installing DBI yesterday. This means I am a
DBI newbie!! If this is not the appropriate forum for my questions please
forgive me and help me finding it. (I am also an english writing
I running perl5 under SUNOS 5.6
I have DBI installed
Here is my error message:
---
install_driver(Oracle) failed: Can't load
'/home/csc/sps/perl/lib/site_perl/5.005/sun4-
solaris/auto/DBD/Oracle/Oracle.so'
for
Make sure you have the path to Oracle libs in your LD_LIBRARY_PATH for the
user which is executing this script, so if it's executed by the server, then
it's probably user nobody, so append it to the nobody's environment, or make
it global.
Ilya
-Original Message-
From: Kevin Quash
1. try this command line:
ldd /home/csc/sps/perl/lib/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so
It will tell you if you are missing some libraries.
You can also use ldd -s (to see more ...)
2. export LD_LIBRAY_PATH=$ORACLE_HOME:$LD_LIBRAY_PATH
3. If you have changed something from
I really appreciate your contributions...I have successfully installed the DBI
module...Thanks to you great people out there...
Thanks alot
Still soon
Chuks
According to the DBI dox, this:
names = map { scalar $dbh-type_info($_)-{TYPE_NAME} }
{ $sth-{TYPE} }
should return the datatype of each column of a SELECT statement. All I
ever get is undefs. Does this not work right under DBD::Pg?
--
Jeff Boes
I saw an example of the following, but I now cannot find it anywhere ...
Can some one share or point me to an example where
data is inserted into two or more (Oracle) tables, but none of the
changes are committed unless the inserts to _all_ of the tables were successful?
TIA
Have you looked at the DBI documentation for $dbh-commit and $dbh-rollback? You
have to make sure AutoCommit is off, but this too is explained in the documentation
for these functions. I found perldoc DBI to be sufficient for anything I needed to
do.
-dpf-
---
David P.
Folks,
I wish to do two things using DBI:
1. Update a table:
$update =update table_A set field_1='Y' where field_2='Y' and serialnum=?
2. Produce a confirmation report on updates I just made
$confirm =select name, number from table_A for those rows I just updated
Questions:
How do I
I use DBD::Proxy from Mac OS X to connect to a Linux server that has
Oracle client libs installed and is running dbiproxy.
First of all, don't set $ENV{'ORACLE_HOME'} on the OS X machine; it needs
to be set for the machine running dbiproxy.
Next, here's what my proxy connection looks like:
my
- Forwarded message from Sabol, Sue Z. [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
From: Sabol, Sue Z. [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: Do you know how to select * from a.table1@oracle_database1 then
insert them into
Hi All,
I've got a problem with code that has been running successfully for months.
I've talked to my DBAs about it and haven't found resolution. What I am doing
is getting the currval for a sequence after inserting a record. below is the
trace information and the oracle error being thrown.
I'm using DBI v1.20 and DBD-Oracle v1.12 on a Sun 250 (Solaris 2.7)
against Oracle 8.1.7. Perl 5.6.1 (complied with gcc 2.95.1). All of the
test suite works 100%.
I have a script which parses the contents of formatted text files and
inserts rows into a holding table in Oracle for subsequent
This is usually indicative of an Oracle error - i.e. a bug in Oracle is
causing your application to terminate on a signal (eg SEGV). Have you
had a look in the alert log and/or the 'udump' directory to see if there
is a dump from your process ? If this is happening 'all of a sudden' I
would
Don't forget to read about the DBI_AUTOPROXY env var in the DBI docs.
Tim.
On Thu, Apr 18, 2002 at 05:31:55PM -0400, David Dierauer wrote:
I use DBD::Proxy from Mac OS X to connect to a Linux server that has
Oracle client libs installed and is running dbiproxy.
First of all, don't set
Rebuilding all current versions under HP-UX 11.0
appears to have solved the problem!
-Original Message-
From: Howard, Chris
Sent: Wednesday, April 17, 2002 3:38 PM
To: '[EMAIL PROTECTED]'
Subject: Troubles on HP-UX with DBD:Oracle
Hi,
Thanks for your time in looking this over.
I
From: Frank Newland [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 13:02
Subject: Implementing Update then confirmation report
Folks,
I wish to do two things using DBI:
1. Update a table:
$update =update table_A set field_1='Y' where field_2='Y' and
serialnum=?
help6
Cleaned up local space -- still can't load db-4-1~1.gz Disk quota
exceeded
Sorry I'm back, but I can't find a mailing list for Berkeley DB questions
(suggestions?).
Haven't been able to load Berkely DB on
System: Unix on Apache
Goal: To load some DB modules and construct a simple flat
Ed Sickafus wrote:
help6
Cleaned up local space -- still can't load db-4-1~1.gz Disk quota
exceeded
Sorry I'm back, but I can't find a mailing list for Berkeley DB questions
(suggestions?).
That still doesn't make Berkely DB installation a suitable topic for
this list.
Goal: To
Yes, you'd want to make two database connections, and once you have two
database handles, you use one to select, the other to insert, then close
both. For more technical details please read perldoc DBI.
Ilya
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent:
connect to a schema in db1, create a db link to b schema in db2 named
oracle_database2 and then
insert into table1 select * from table2@oracle_database2
one db handle, one connection within perl, assuming tables are the same..
use append hint to do direct load insert bypassing evaluation
My name is Ryoji Watahiki .
I work for Japanease company.
$B#I!!(Bhave been developed Intranet Web system by
$B#P#e#r#l!\#D#B#D!'#D#B#I!!(BOracle.
I want to control of enable or disable of Trigger on Web.
I tried below this ,but it could not work well.
$B!!(B $B"-(B
Delivered-To: [EMAIL PROTECTED]
From: Sabol, Sue Z. [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: Do you know how to select * from a.table1@oracle_database1 then
insert them into b.table2.@oracle_database2
Date: Thu, 18 Apr 2002 17:20:40 -0400
Do you know how to select
From: "Ryoji Watahiki" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 21:59
Subject: How to Control of Triiger on Web
My name is Ryoji Watahiki .
I work for Japanease company.
$B#I!!(Bhave been developed Intranet Web system by
$B#P#e#r#l!\#D#B#D!'#D#B#I!!(B
- Original Message -
From: "Ryoji Watahiki" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 1:59 PM
Subject: How to Control of Triiger on Web
(snip)
==
$enb_trg ="alter trigger test_trg enable";
$dbh-do("enb_trg");
My name is Ryoji Watahiki .
I work for Japanease company.
$B#I!!(Bhave been developed Intranet Web system by
$B#P#e#r#l!\#D#B#D!'#D#B#I!!(B
Oracle.
I want to control of enable or disable of Trigger on Web.
I tried below this ,but it could not work well.
On Fri, 19 Apr 2002 14:50:08 +0900 Ryoji Watahiki [EMAIL PROTECTED] wrote:
In fact. cording is $dbh-do($enb_trg)
I tried it in your way before,but the result is same.
$dbh-do($enb_trg) --NG
$dbh-do($enb_trg)--NG
What did you see (or not see) that caused you to decide that either of
54 matches
Mail list logo