Perl > dbi-dev > March 2006

I've recently surfaced a bug in a pure Perl DBD that ChildHandles solves quite nicely...except it appears to require Scalar::Util, which is not a CORE module (tho perhaps it should be). While DBI ...

Trailing \r characters are trimmed on varchar2 fields. HP-UX 11.11 Oracle 9.2.0 perl-5.8.5-64all-dor DBI-1.50 DBD::Oracle-1.17 DBD::Oracle states: --8<--- ORA_VARCHAR2 Strip trailing spaces and allow ...

This patch allows LOBs to be bound to input variables. I wanted to send large amounts of data to stored procs without using a temp table (or, at least wanted to see if I could). I've thought of ...

I always that the binding undef's in DBD::Oracle was the way to bind a null, yet: DB<5 x $dbh- selectall_arrayref('select x,b from tbl where a=?', undef, 4) 0 ARRAY(0x9b53010) 0 ARRAY(0x9ba6284) 0 ...

Hey guys. This one has bitten me one too many times. Given this table: CREATE TABLE foo ( foo_id INT, bar VARCHAR(255) ); This prepare() and execute() produces a very helpful warning: my $sth = $dbh- ...

Fellow DBIers, I've been having a need in my tests to be able to disconnect all current connections to a database—before I drop the database, for example. Now my code uses connect_cached(), so this ...

Here's the second revision of my LOB patch. This allows LOB locator refs to be bound to PL/SQL input placeholders, and auto-converts strings to and from LOBs when ora_auto_lob is set. When an output ...

[ This got warnocked on dbi-users, so I'm posting here too. When I originally posted, I was using DBI 1.41. I have since upgraded to DBI 1.50 which did not help. ] Hi list. I believe I have tripped a ...