Webmaster Forum / Perl / DBI Library / February 2007

Hey all,
I'm trying to write a simple Perl program to read and display the
schema of a database.  I have a DBI->connect call that looks like
this:

I got a solution for this problem so I thought you might be interested to hear it.
At Martin's advice I called Microsoft and Hans Lindgren from Microsoft Product Support confirmed the bug and found a workaround. I got the the OK from Hans Lindgren to post the summary of the case ...

I am crossposting from dbd-pg@perl.org, as the other list appears to
be dead.
I am writing the answer to my original question [<a href="http://
www.nntp.perl.org/group/perl.dbd.pg/2007/02/msg60.html">see

----- Forwarded message from Bob Hunter <catdogbeloved@yahoo.com> -----
Date: Tue, 27 Feb 2007 08:03:19 -0800 (PST)
From: Bob Hunter <catdogbeloved@yahoo.com>
Subject: DBI's method for reading [row x,field y]

The module DBI::Format generates an output that is very similar,
whether not identical to the one I used to have with ->pring under Pg.
The problem is, that it prints on the console only. Is there any trick
to redirect the output to a named file? Also, if you are not using

To DBI support group,
  I am trying to install the Perl DBD-Oracle-1.19 on AIX 5.3.04. The
process was hung in there.
root@amber:/tmp/DBI/DBD-Oracle-1.19# perl Makefile.PL

I Just discovered that when using:
$param = substr($param,0,length($param));  # apparently a NULLOP
$sth->execute($param);
instead of just:

Hi ALL. Is there a relation between the version of
DBD::Oracle and Oracle 10g.
The performance of executing the SQL statements is low
comparing to mysql performance.

Miracles never cease - blame it on a snow-storm in Lake Tahoe, CA and
wireless connectivity.
OTOH, the upload of version 2007.0225 included the wrong Announce file -
hence version 2007.0226.

I have DBIx::Log4perl which is currently connected to a DBD::Oracle. In
DBIx::Log4perl::st::execute I want to call DBD::Oracle's dbms_get_line
which is usually (from applications) called like this:
@lines = $dbh->func('dbms_output_get');

I'm trying to change the text of error messages, for example the following:
DBD::SQLite::db do failed: table X already exists(1) at dbdimp.c line 269
From the user's point of view, "table X already exists" is valuable
information, but "at dbdimp.c line 269" is useless.

pretty new to CDBI - trying to use it in a mod_perl environment and have
seen some info on it and a recent thread -
http://lists.digitalcraftsmen.net/pipermail/classdbi/2006-November/001407.html
- but still having "caching" issues.  I am pretty sure that my issue is

This patch fixes the fact that DBD::mysql doesn't clear out the
sth attribute cache when switching between result sets, and doesn't
adjust NUM_OF_FIELDS.
Other driver authors please note the new 'official way' to adjust

The DBD::mysql do() method doesn't set $dbh->{Statement} attribute.
This means:
a) using DBI::Profile doesn't give correct profile results for calls to do()
b) using ShowErrorStatement may report the wrong statement in the error message.

I have been trying all night to get DBI 1.53 installed on Perl 5.008 that comes with RHEL 3.0.  When CPAN failed I have tried downloading and compiling, however I get the same problems.  Here is a snapshot of the process:
[root@agamemnon DBI-1.53]# perl Makefile.PL
*** You are ...