Webmaster Forum / Perl / DBI Library / September 2007

Just attempted to install DBD::Oracle 1.19 on an Ubuntu Server 7.04
Feisty machine running Perl v5.8.8 (and instant client
10.2.0.3-20061115) and hit a problem with the Makefile.PL not being able
to determine my Oracle version. The symptom is:

I have a fairly critical program which takes a LONG TIME to run and I
would like to make it faster.
When I run it thru the profiler, it appears that most of the top 15 time
consumers are in Class::DBI, but I am a DProf n00b.

I'm trying to get an Oracle client working under Linux and I'm having
problems running a test script. Here's the error:
[koczan@ator] lab $ perl oracle.pl
perl: symbol lookup error:

On 9/17/07, Edward J. Sabol <sabol-2oVx0MVsMgiP/wAdlnoHchvRvTJiVFUC@public.gmane.org> wrote:

a few days

Hey guys
I am trying to query a table using a database link, using the following
code:
use strict;

I can't install DBI-1.59 on ubuntu 7.04 with
This is perl, v5.8.8 built for
i486-linux-gnu-thread-multi
Seems like ubuntu lacks some files. but which?

I'm hoping someone can answer a couple of questions for me on
DBD::Oracle and child signals. I have several perl scripts that use
DBD::Oracle to establish a connection to my database. In these scripts,
I'm also executing system commands to launch external processes. What

I just saw on http://use.perl.org/ that DBD::SQLite 1.14 has been released.
Anyone want to be a guinea pig and test it with Class::DBI? The Changes file
gives some hope in that it claims to have fixed various problems with
preparing statement handles. Hopefully, 1.14 has fixed that ...

I am listing the patch (diff file).
The REF CURSOR array-fetch can be turned on using something like
"$dbh->{RefCursorCacheSize}=16;".
Array fetch remains off by default (single row fetch) so that it will not

Well, I've figured out how to put data into a sqlite database.  I can
extract data from the command line, however, for the life of me, I just
can't find any good documentation on using Select.
What I'm trying to do:

I'm working on a project where we have data stored in arrays that we need to
put into a database.  We'd started with CSV (it was easiest), but it's
become unmanagable.
However, I don't want to go through the pain of getting a mysql database or

just done a new install of DBD::Pg, on a fresh machine. Have been
through the usual steps ... :
- get it to compile
- set up a test db

Running DBI 1.58 and DBD::Oracle 1.19 with Oracle 10g (10.2) on Fedora 7
64 bit OS:
Copying a table from one tablespace to another tablespace (two $dbh
handles).  The table has 56 fields.  I've simplified the process to:

G'day all
I'm trying to get DBI::ProfileDumper::Apache working under mod_perl 2
and am having no luck at all. I've followed the easy instructions as per
the doc and put into my httpd.conf's <VirtualHost> section:

I am having a problem using DBD-Oracle.
Basic problem - I can only get a connect to work when I fully
specify the connect string, i.e.
"dbi:oracle:host=xxx;port=yyy;sid='zzz' ....