You mean to say ActiveState is building DBD::Oracle
for current versions of Perl with current Oracle libs?
I took a look at the status just now on ppm.activestate.com
for Perl 5.8, and the status is FAIL for DBD-Oracle.
Jared
On 4/30/06, Jeff Urlwin <[EMAIL PROTECTED]> wrote:
I can tell you
Hi John,
Thank you for your reply.
We have rebuilt DBD::Oracle with 9.2.0.7; sorry for not mentioning so
in my previous email. I asked our systems administrator about the
oracle patches and he says it's up to date.
Any other thoughts/comments?
Thanks,
-Tobin
As far as I understand DBD::Oracle (the driver DBI uses for Oracle), it
is "just" a translator for the Oracle Call Interface (OCI), and to my
knowledge, OCI uses TNSNAMES.ORA. If you use a recent Oracle client
software, the OCI may perhaps emulate a TNSNAMES.ORA based on the Oracle
Internet Dir
Is there anyway that I can force Perl DBI to not use TNSNAMES.ORA and
instead use Oracle Internet Directory?
-Original Message-
From: Alexander Foken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 02, 2006 11:29 AM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: Re: DBI->data_sources(
Peter J. Holzer wrote:
On 2006-05-01 14:07:02 -0400, Robert Hicks wrote:
It tried to connect with the scott/tiger thing on a lot of tests...and they
fail (of course).
You can tell the testsuite to use a different user by setting the
ORACLE_USERID environment variable. E.g.,
export ORACLE_USER
> -Original Message-
> From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 02, 2006 2:15 PM
> To: DBI users
> Subject: DBI->data_sources('Oracle')
>
> Hi All,
>
> Will someone please tell me where this module is getting the
> information from? One of my severs that I a
First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA or
$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA.
Alexander
On 02.05.2006 20:15, Loo, Peter # PHX wrote:
Hi All,
Will someone please tell me where this module is getting the information
from? One of my severs that I am trying to connect to is NOT
Hi All,
Will someone please tell me where this module is getting the information
from? One of my severs that I am trying to connect to is NOT listed in
the output of:
@databases = $dbh->data_sources('Oracle');
Thanks.
Peter
This E-mail message is for the sole use of the intended recipi
Not really a good list for that. Try an SQL list but here is one answer
update table.x set field.x=field.x+1
No doubt there are hundreds of other ways to do this.
- Original Message -
From: "Akpome Akpoguma" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 02, 2006 9:40 AM
Subject: Incremen
Hi Everyone,
I want to increment the value of a field in a table by 1. How do I go about
this?
I tried 'update...hits+=1' but it didnt work.
Your response would be appreciated.
Rgds,
-
How low will we go? Che
Hi all!
I'm using DBD::SQLite and with the following program or similar, I'm getting a
"closing dbh with active statement handles" warning:
<<
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect("dbi:SQLite:dbname=test.db", "", "");
$dbh->do("CREATE TEMP TABLE test (a INTEGER, b INTEG
There are some critical patches for 9.2.0.7 . Have you installed them?
This might clean up your problem.
One other though have you rebuilt your DBD::Oracle with 9.2.0.7?
"Tobin Stelling" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> My coworkers and I have a question r
If @names was a few records, you could write something like
select ... where name in (?,?,?,?,?)
using some Perl code to generate the placeholders ( join(',', ('?') x
scalar @names) ). But with 100,000 records, i think this would bring
DBI, DBD::Pg and the Pg SQL parser to their limits. Usual
On May 1, Bealach Na Bo scribed:
> Hi folks,
>
> Apologies if this has been asked and resolved - I've spent half a day
> searching various archive, but have not found anything.
>
> My problem is the following:
>
> I have a very large postgresql table (ca. 3 mil records) and need to
> replace a nes
Hello,
My coworkers and I have a question regarding the SQL statement that
DBD::Oracle's column_info() function executes. We depend upon
column_info() to discover the data type of a large object column is
so we can bind it properly.
While this worked great for us in the past, when we upgr
Hi Peter,
in case You just want to be shure not to destroy an already existing
table by creating it again, You can just isse an $dbh->do("CREATE
TABLE..."). An already existing table will never desroyed and a warning
will be raised.
Greetings
Robert
-
Loo, Peter # PHX wrote:
Hi Al
On 2006-05-01 14:07:02 -0400, Robert Hicks wrote:
> It tried to connect with the scott/tiger thing on a lot of tests...and they
> fail (of course).
You can tell the testsuite to use a different user by setting the
ORACLE_USERID environment variable. E.g.,
export ORACLE_USERID=hicks/[EMAIL PROTEC
17 matches
Mail list logo
