I have problems using DBI:Proxy / DBI:Proxyserver with an Oracle
database. In fact, I am not sure that I start the proxy properly.
I'd like to connect to a remote Oracle database (called 'abc') running
on machine A (ip=1.2.3.4), port 1521.
First, on A, I created a proxy startup file:
Peter,
Can you repeat this same issue in SQL*Plus?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Peter Santos [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 08, 2005 9:00 AM
To: dbi-users@perl.org
Subject: re: Oracle 10g and DBD::Oracle
Dear users,
I'm hopi
Dear users,
I'm hoping to get some insight into why oracle creates 2 cursors for
the same sql query when I execute a SELECT statement via my small little
perl script.
Here is what is happening .. My query uses 2 bind
variables and when it is prepared oracle generates 1 cursor for my
query.
W
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
> The SQL I would use is:
> SELECT Names.Name, Names.Age, Ages.Description
> FROM [Names] LEFT JOIN Ages ON Names.Age = Ages.Age;
>
> But DBD::CSV (that is, SQL::Statment) doesn't support the 'LEFT JOIN'
> syntax.
According to the docs, SQL::St
Tim Bunce wrote:
> On Mon, Dec 05, 2005 at 11:01:33AM +0100, Tom Schindl wrote:
>
>>Hi,
>>
>>I've already asked at the mod-perl-list about the new connection pooling
>>provided by Apache2.2 with
>>http://httpd.apache.org/docs/2.1/mod/mod_dbd.html but they redirected me
>>to this mailling list.
>>
Tim Bunce wrote:
On Mon, Dec 05, 2005 at 11:01:33AM +0100, Tom Schindl wrote:
Hi,
I've already asked at the mod-perl-list about the new connection pooling
provided by Apache2.2 with
http://httpd.apache.org/docs/2.1/mod/mod_dbd.html but they redirected me
to this mailling list.
Has anybody tak
