(snip)
> I tried it in your way before,but the result is same.
> $dbh->do("$enb_trg") -->NG
> $dbh->do($enb_trg)-->NG
>
> I tried below this(debug mode) ,but print sentence of debug mode
display
> until finish1.
> So, I think the part of "$dbh->do($enb_trg)" is incorrect or illegal..
Did
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
> 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.
>
> =
- 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");
> ==
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!!
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
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
==
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 buffer
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: Thur
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.
>
> Go
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
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
seri
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 c
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 $
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
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 proce
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.
T
- 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 b.tabl
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 $
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 implem
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
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
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 really appreciate your contributions...I have successfully installed the DBI
module...Thanks to you great people out there...
Thanks alot
Still soon
Chuks
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 O
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 [contr
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 module
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 ne
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
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 t
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 instal
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
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 2>&1 | 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
-I/usr/users/u860323/lib/p
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 recordse
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. No
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: [EMAI
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.
>
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
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 err
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 5
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"}) {
>
>
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_r
'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],
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 s
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 nast
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 r
Does anyone have a link of info on how to build DBD on HPUX 11i...
Thanks
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
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.
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 vers
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 Message
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 function
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 contai
Is there anyway to build DBD so that it can be used with either various
version of Oralce 8 and Oracle 9i.
Thanks
AG
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
/usr/lib/perl5/site_perl/5.6
55 matches
Mail list logo
