Webmaster Forum / Perl / DBI Library / March 2006

This email for Tim Bunce or anybody who knows the answer to my problem.
Here it is:
I use to install DBI module as
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBI.ppd

I've been looking for open source applications using Class::DBI.  It
would be very didactic to see real-world examples.
In my case, as my project grows, I'd like to see how people have
designed their class hierarchies around CDBI.

I've STFW for this error & got back many results but did not find
anything relevant to the problem I think I'm having.
Perl script on windows-xp (perl 5.8.6.811, DBI 1.50, DBD-mysql 3.0002)
trying to connect to a mysql server on a unix box running

When/Where is take_imp_data() called in DBI.pm? I was passing around a
Database handle and suddenly I think I lost the database handle. I'm
not exactly sure as to what happened but subsequent operations using
the database handle failed.

Hi, I am trying to install DBI to run a DBtest Script that was written by a
vender. Here is the error I got, the version, and the script I am trying to
run. Unfortunately, I am not very familiar with Perl.
Please let me know if I need to install something else in Perl or make other

I think I may have found a bug in DBD::mysql for execute_array.
The following code demonstrates:
#!/usr/bin/perl
use strict;

I have subclassed DBI and override many methods including prepare, execute and
select* although they are predominantly just passed on to DBI.
If I do:
my $sth->prepare(sql);

According to the docs for execute_array:
"The mandatory ArrayTupleStatus attribute is used to specify a reference to
array which will receive the execute status of each executed parameter tuple."
It would appear in DBI 1.50 you can omit it:

There are several to-do items regarding utf8 that would be
great, but aren't here yet.
My database has utf8 columns, server/client character sets and
collation.  Yet when I call fetchrow, resulting Perl scalars do

Sir,
 Please provide me the help to upgrade the latest of DBI.
 I am using Oracle 9
 It shows error:

Looking to see if anyone has already implemented this (other than mst
in CDBI::Sweet).
I have a view that joins CD and Artist.  One of the columns in
the view is an artist id.  So, as is typical, I have:

I am trying to connect to one Sybase database in a parent process and
other Sybase database in a child process.  I was able to do this under
Perl 5.6 but the same code no longer works under Perl 5.8.7.  Here is a
sample program which replicates the problem:

I've come across a situation where a client needs a change in
requirements which would, ideally, require a slight slight breaking
out of one class into a base class and two sub classes.  Put shortly,
I have an event which is based on due dates right now, but some

I have my own error handler in which I'd like to log as much detail about the
error as possible. In this handler I do something like:
sub _error_handler {
   my ($msg, $h, $method_ret) = @_;

Hi Tim,
I have a problem with perl operating with DBD-Oracle. The error i get is
as follows -
DBI connect('edwtest','i2_read',...) failed: ERROR