Webmaster Forum / Perl / DBI Library / July 2006

I'd appreciate testing of this release candidate:
 http://www.data-plan.com/public/DBI-1.52-RC1.tar.gz
=head2 Changes in DBI 1.52 (svn rev 6734),   30h July 2006
 Fixed memory leak (per handle) thanks to Nicholas Clark and Ephraim Dan.

As another episode of the DBD::Oracle on MacOSX quest, I tried the
Oracle 10g Instant Client for 10.3 on Panther, using DBD::Oracle 1.16
(the latest I believe).
First the good news (and it's primarily good news). The Instant Client

I know this is one of those how long is a piece of string questions but
I cannot see any difference using prepare_cached with a remote mysql or
oracle database. I have code which does inserts/updates/selects - around
20 - 30 different pieces of SQL and most of them are run between a ...

I want to add a "me too" with a description to the messages in
DBD-Oracle-1.18/err_unicode/err_twolongstr.msg. I also get the
    ORA-01461: can bind a LONG value only for insert into a LONG column
message after moving my system to UTF-8.

 I'm using PERL 5.8.7, with modules DBI (version 1.49)  and DBD-Oracle
(version 1.16) with Oracle 9.2 and have the following problem
Here is my SQL statement:
$SQL = INSERT INTO Supplies ( CompanyID, SupplyDate, SupplyTypeID )

Hi..
Having trouble getting to the 'WHERE' to work in a sql statement..  The
statement I'm using is:
$query = qq{select UserName, UnitSN from tUser WHERE

I suspect that I know the answer already but ..
does DBD::mysql (or the MySQL API for that matter) support random
access to BLOB types ? i.e. the ability to select/insert
a BLOB via a serious of small queries, as opposed to the

I built DBD::Oracle 1.17 on a RHEL AS4 machine using the Instant Client
libraries.  I can use it and DBI 1.48 quite successfully to connect to our
Oracle 10 server via CGI or command-line perl.
The same code, however, segfaults with the stack trace attached below when

This is my first email to the group and I hope  that I landed in the
correct place.
Ok now coming to the problem. Can someone explain to me that what this
script is doing. I want to know the meaning of all the lines in the

Hi, I'm seeing the following warning message from DBIx::ContextualFetch
intermittently.
Use of uninitialized value in null operation at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.

I've been trying to find a reliable method for timing out queries that take
too long.  I only see a connect timeout in DBI but nothing for timing out a
query.  We can't set a timeout on our database either.  I've attempted to
use DBIx::DWIW without success.

I am undoubtedly going to sound like an idiot somewhere in this email.
I absolutely need to minimise / limit the number of DBI connections and
hopefully without impacting performance too much.
I would like to use something like ResourcePool for the DBI connection

DBD-ADO version 2.95 appears to have a problem with the bind_param command when using the SQL type constants.  The problem does not occur with version 2.94.  See the dbi-users posting "Possible bug in DBD-ADO 2.94 bind_param" from September 24, 2005 for more info.  See below for ...

I have had (& reported) this problem before and managed work arounds, but now I've got no choice but to get transactions working through DBI. The following simple script always fails:
#!/usr/bin/perl -w
use DBI;
my $user = 'root';

----- Forwarded message from Oscar Gomez <ogomez@epq.com.co> -----
X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no PTR record, or PTR and A records do not match
From: Oscar Gomez <ogomez@epq.com.co>
To: Tim Bunce <Tim.Bunce@pobox.com>