Webmaster Forum / Perl / DBI Library / July 2009

Just a quick question about DBIh_SET_ERR_SV. I've produced a patch for
DBD::Oracle and it failing to handle non-unicode strings but running our
test code against DBI 1.609 produces a segfault. It appears:
DBIh_SET_ERR_SV(h, imp_xxh, errcode_sv, errstr_sv, &sv_undef , &sv_undef);

I am having difficulties connecting to Microsoft SQL 2005 from a Perl script.  I am using DBI 1.609 with unixODBC 2.2.8 and freeTDS 0.82.  The commands isql, tsql -H, and tsql -S all connect successfully and respond as expected to queries, but when I try to connect through DBI, I ...

Hi, the www.midsomer.org site seems down at the moment, do you know the current home
of dbschema.pl?
I have the URI <http://www.peppler.org/downloads/dbschema-2_4_2.zip> but I don't know if
this is the latest version.

Consider this:
my $sth = $dbh->prepare("INSERT INTO [DATATEST] ( [billingterms], [carrier], [class (1)], [class (2)], [class (3)], [class (4)], [client], [consignee], [cube (1)], [cube (2)], [cube (3)], [cube (4)], [description (1)], [description (2)], [description (3)], ...

while calling $dbh->disconnect() at the end of my database operations, I get the
warning that there are still active statement handles. But when I ckeck it I
could not see any active statement handles. Any ideas how this could happen?
Here is the output of my debugging:

I'm having trouble binding an Oracle object type using the bind_param_inout method. The error I get is "PLS-00306: wrong number or types of arguments". The column specified has an Oracle data type of "object".
I am trying to call a stored procedure with inout parameters.  One of ...

I need to export contents of a table whch has one data type as CLOB.
I am able to store it ina file using query, "select PROFILE_ID ||'#COL#'||
ADM_TYPE ||'#COL#'|| ACC_TYPE ||'#COL#'|| STATUS ||'#COL#'|| ACC1

What solutions are available, if any, to work with a master and multiple
slave database configuration that would be transparent to the application?
That is, send all select requests to the slaves but writes, and explicit
transactions (begin, select for update) go to the master.   ...

I am attempting to install a shareware library administration system
called koha which is written in perl.  I have used cpan to install a
large number of perl modules, including DBI.
But when I try to connect to DBI I always get the message in the above

I have compiled a static version of perl and attempting to install DBI
and DBD drivers also.  This is the error I receive...
Can't load module DBI, dynamic loading not available in this perl.
 (You may need to build a new perl executable which either supports

i have unset my LANG (unset LANG) but the build program doesn't seem to complete on "install DBI"
my perl -v is:
bash-3.2# perl -v
This is perl, v5.8.8 built for darwin-thread-multi-2level(with 4 registered patches, see perl -V for more detail)

I stumbled over somthing very strange: When I try to update data in a table, the
 input parameters are going into the right fields - exept the first data row in
the table / file. Below is a script which demonstrate the thing. Running the
first time, it creates the table ...

I am doing a prepare/execute/fetchrow_hashref and for columns that have
names longer than 30 characters, the hash key is truncated to the first
30.  Is this a  known issue, and if so, is there a workaround for it?  I
am using unixODBC 2.2.11 and and DBD::ODBC 1.17 (also tried this ...

During the last months I recogrise that Emails I sent to the list needing an
unusual long time to sent back to me - around 4 hours, sometimes some hours
more. But yesturday my mail needed more than 21 hours to reach the list (or at
least me). I sent it an 10:10 GMT and reached my ...