Webmaster Forum / Perl / DBI Library / May 2006

My make tests in CPAN are crashing hard when I "install DBD::Oracle"
Solaris 10.2. perl version 5.8.4 built for sun4-solaris-64int Oracle10g
client Admin installed.
The first error I get is:

I have a perl 5.6.1 installation with DBI and DBD:Oracle with Oracle 9i
When I try to run a script to make a connection with Oracle 10g using
the above Perl executable, I get the error Unable to initialize OCI, OCI
Initialize failed 1804.

After searching for a while on Google, I am still not able to find an
answer to the following issue. Running $dbh->prepare($sql) fails because
of a segmentation fault. I don't manage to fix this issue. Any idea
about this would be welcome.

Is there an equivalent to "perltidy" for sql?
I have a bunch of sybase stored procedures that I did not write, but I
have to maintain.  The author had a "unique" style of indentation.  (I
think it involved a variable width font, among other things.)

Recently I upgraded from 3.0003 to 3.0004.  I noticed that I suddenly started receiving tons of warnings from my Class::DBI scripts such as:
statement handle DBIx::ContextualFetch::st=HASH(0x18bfe60) still Active at /usr/lib64/perl5/site_perl/5.8.8/Ima/DBI.pm line 381
It seems like ...

I just installed DBI-1.50. The only problem I had is the following test:
not ok 60
# Test 60 got: '25 0.93 0.11 1e-02 0.23 1023110000 1023110010'
(t/40profile.t at line 202)

Does anyone know why the oracle child process initiated by my perl
program with parent ID of 1?  
My system is HPUX 11.11 with PERL5.8.0, DBI1.48, DBD-Oracle-1.16,
Oracle10.2.0.

I'm using CDBI 3.0.6 (latest in the Active State PPM repository), and
I'm doing some testing against MS SQL Server 2005 (Express version) as
the DB.
I initially built and tested my code against SQLite, but am trying

I get the following errors while executing the DBI module of perl.
Please help me find out the reason of this error.
install_driver(Oracle) failed: Can't load
'/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/Ora

I saw on the web that the Oracle array interface has not been implemented
properly. I am new to DBI. Has the implementation been made more efficient?
Thanks,
Shree

All -
  Would it be possible to change AutoCommit to $dbh->in_transaction()
returning the number of nested transactions and a value of 0 meaning
"Not in a transaction"? Then, begin_work actually

I'm working on scheduling daemon in perl, it uses C::DBI to handle
DB/Object Persistence, etc as you'd expect.
Unfortunately I'm having issues with the ammount of memory it uses
after 24 hours of running.

I'm trying to load balance reads across two MySQL database that have replication.  The reads are working wonderfully.  The inserts actually do insert.  However, there are some table that use auto increment primary keys.  I can't figure out how to actually get those particular ...

If you are installing sybperl-2.18, is there any reason to install
DBD-Sybase-1.07?
Does it do any damange to have both installed like I do?
Thanks,

I have an interesting requirement and am hoping that I can obtain a
solution here.
I have the need to get several billion rows from multiple Oracle tables
to tables on a "Netezza" database.  I have tried several ways to get the