Webmaster Forum / Perl / DBI Library / December 2007

I have a csv file. I defined the column names inside the perl script
but "sql insert" does not work. If the csv has column names, the
script (without col names defined) works.
sql select works on both csv with or without column names.

I'm converting an older program for use on Sybase 15.  In this process
there is a routine that used DBlib's BCP routines which I'm dutifully
converting to CTlib's BLK routines.  The conversion has gone well except
for the insertion into the BINARY(16) fields.  Using the BLK ...

we just installed DBD Oracle 1.19 on Linux suse.
oracle 10.1.0.3 full version has been installed on the same box prior
installing DBD
and the db instance is accessible.

Class::DBI::Sweet 0.09 is now available for public consumption.  This
release fixes all bugs filed against version 0.08 except for a minor time
zone bug which I haven't been able to replicate.
Get it here -

I am converting some messy scripts I wrote to use the very nice Class
DBI interface.  I have run into a wall that I can't seem to figure out
(please forgive me if this is easy and I am just ignorant).
I have multiple sites running mysql using master -> slave replication.

You wrote:
------------------------------
If LD_LIBRARY_PATH is set to the old OCS-12_5/lib directory
(P-EBF11356/DRV.12.5.1), everything is fine again.  Set LD_LIBRARY_PATH

Folks,
I am facing a funny but troubling issue with Perl DBI & Oracle.
When my shell environment does not have ORACLE_HOME path set, my script
works fine. I am connecting

Hi,
Can anyone help me resolve this problem?

Hi, i'm newbie in perl programing
 I have some problem when installing squid2mysql, the problem occur when starting squid:
 #service squid start
Starting squid: "use" not allowed in expression at /var/log/squid//squid2mysql line 23, at end of line

I have a perl script which updates some (large) tables from text-files,
inserting, updating and deleting records. For performance reasons the
inserts, updates and deletes are queued together and then done with an
array operation when there are "enough". Now I've added another table

My app uses cdbi for data acces, and CGI::App running in a mod_perl
environment.  Basically, just my CGI running under Apache::Registry.
My application runs reports and persists status to a Sybase database.
We've recently implemented an AJAX status update for the status web page

I am confused as to why I am getting this error message.  I am trying to
connect to two different Oracle instances within one program run.  The
two Oracle instances are different in versions.  inst1 is 9.2 while
inst2 is 10.2.  I am able to connect to the first instance without

I've been playing around with the DBD::Oracle 1.20 RC4 embedded object  
support and found that I get segfaults unless I apply the following patch:
--- oci8.c.old  2007-12-13 16:54:45.625233000 -0500
+++ oci8.c      2007-12-13 16:48:21.204639000 -0500

When I try to run a perl script that uses ODBC drivers to insert data
more than 70000 rows I am getting the following error....
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
Server]Procedure  has no parameters and arguments were supplied.

I have a db field of type "timestamp with time zone" (Postgres). I
also have a CDBI class for that table which uses Class::Date, like so:
__PACKAGE__->has_a (last_update_dt => 'Class::Date',
                   inflate => sub {