Webmaster Forum / Perl / DBI Library / September 2005

I'm interested to hear stories of people who have subclassed the DBI,
or used modules that subclass the DBI.
Was subclassing the DBI a good approach?
Where there any problems?

Perl 5.8.7
Solaris 10
DBI 1.48
DBD::Oracle 1.16

Setting: Perl 5.8.2 on Solaris 9
We need to set these 2 environment variables from Perl:
$ENV{DB2INSTANCE} = 'db2inst3';
$ENV{LD_LIBRARY_PATH} = '/export/home/db2inst3/sqllib/lib';

SQL-Interpolate 0.31 is now available on CPAN:
http://search.cpan.org/dist/SQL-Interpolate/ .  This includes a new
("WHERE", {x => \@v, ...}) syntax, bug fixes, and clarified
documentation.  Discussions on the module will now take place on the

i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4 and DBI version
1.46 with DBD::Pg version 1.32.
i can create tables from psql with an $ in the middle of it, e.g. "create
table foo$bar (id integer);"

  This is a reposting of a message.  I was advised that my attached code
did not make it through.
  Basically, I am running ActivePerl 5.8.7 and mySQL 4.1 under windows XP.
Although I can handle data manipulation statements through DBI,  it balks

Michael,
These 2 packages are almost completely empty, and do not refer to any
other tables themselves.  They cannot, of course, because they are being
used by multiple other tables/modules by different names, in a one-way

_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/QYEcJ3gjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4@public.gmane.org
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

I am getting a "Numeric value out of range error" when specifically
binding a placeholder for a decimal column as a decimal type. I'm using
DBD::ODBC connecting to Microsoft SQL Server from a Solaris machine.
The value being bound is 10.00.  The settings in database are precision

    The following statement (trying to insert a duplicate row)
    $sth->execute() or die "could not execute insert: $sth->errstr\n";
returns a value of DBI::st=HASH(0x14065d780)->errstr for $sth->errstr.
Is that normal.

Use of "die" directive along with $sth->errstr prints out
all internal errors. Is there any mapping in the package
which would allow me to print out a meaningful text based on
error returned. Error code (ORA_????) seems to be imbedded in

Anyone seen this?
----------
#!/usr/perl5/bin/perl
use DBI;

Using prepared statements doesn't work correctly for driver DBD-ADO
version 2.94 on MS SQL Server 2000 (Provider=sqloledb).
Given CREATE TABLE t1(c1 VARCHAR(255))
The code snippet triggers the error:

Is there a module already existing to memoize non-place-holding sql
statements to place-holding ones and suppress prepare to minimum?
I'm now transforming other peaple's scripts for a performance inprovement.
This system is so big, I cann't understand quickly, but I foud that all

I need to obtain metadata about the columns in my database.
The problem is that column_info does not supply information about the
signedness of the column, or I am missing something in the man page.
I've googled for some time but found no solution.