Webmaster Forum / Perl / DBI Library / April 2005

I'm designing a database schema that uses the ORDBMS table inheritance
features of PostgreSQL to make two tables inherit from a common third table.
I wanted to know if there was any way within Class::DBI to express that
relationship, so it will DWIM.  Consider the following ...

When I install DBD::Oracle module, I get the following error.
=============================
ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class:
ELFCLASS64

I am having a problem installing DBI giving me this error:
gcc -c  -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xdepend    -DVERSION=\"1.48\"  -DXS_VERSION=\"1.48\" -fPIC -I/usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE -DDBI_NO_THREADS Perl.c
gcc: language depend not recognized

I've got a Class::DBI object which is being destroyed without saving
changes, and trying to track down where it's created.
Thus, I'm trying to find out what it's address is. Usually with a Perl
object, I'd just print it, because the stringification operator tells me

I have a program in perl running on Linux, accessing a SQL Server database
via ODBC. It runs fine. But yesterday, the process had been running for six
days when suddenly, one specific select statement/fetchrow_hashref stopped
returning any data from the database. There were other ...

I'm trying to build a relatively simple object relationship, two tables
containing the following (to start)
Table Name: treasures
id    url

I'm having trouble building DBD-Sybase-1.05 on Solaris 7 with perl
5.005_03 and DBI-1.28
$ make
gcc -B/usr/ccs/bin/ -c -I/opt/common/sybase/include

I downloaded the DBD-Sybase-1.04_17.tar.gz from your site
But tar -xv gave me the error message
Tar:blocksize=4 directory checksum error
-----Original Message-----

This is a shot in the dark, but I wonder if anyone has come across an
error like this under a mod_perl environment.  I'm unable to duplicate
outside of our production environment, which makes this quite hard to
track.

In the case of lock wait timeout, it might be useful to wrap all INSERT
and UPDATE commands in something which tried the connection a fixed
number of times in the hope the lock timed out; has anyone already done
this?

Hey folks,
I'm running into a problem wherein I periodically get fatal errors
about prepared statement handle "dbdpg_13" already exists.  This will
happen even with different queries, accompanied by fatal errors about

I have fresh install Solaris 9. We have some perl scripts to run. I am
getting "Can't locate DBI.pm" error to execute the file. We access
oracle 9 from this perl script. Can some one help me to fix this
problem?

Is there any way to bind a CLOB into the XMLType.createxml() call?
The createXML has 4 different signatures, one is varchar2, one is clob.
If the data is larger than 32k, I need to bind in a clob, but I am not really sure how to do it.
I read the DBD::Oracle docs and looked at the ...

I am not sure this is do-able.  Any suggestions?
I have two objects:  eventpost and eventdatename2.   Eventpost has two
FK fields that are composite primary keys  in eventdatename2.  I use
might_have as a relationship. Is that right?  I can't access

I have recently come across a problem with cPanel/Fedora and DBI. After a recent
update of cpanel the exim stats script stopped working, and produces the
following error:
Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: