Webmaster Forum / Perl / DBI Library / August 2005

Need some help from the Gurus.
I am executing a perl script (with DBI/DBD for Oracle 9i). The script
runs for few hours. But it is getting aborted abruptly in between. The
only message displayed on the terminal is:

We are encountering a problem when we connect to an Oracle database and do not
provide the database name in the connect string.  
The ORACLE_HOME that the DBD was compiled against is
/app/oracle/client

I'm having a problem where the error string from a raiserror (inside a
stored procedure) is disappearing.  I've reduced it to the fact that it
only occurs if there is some part of the stored procedure that returns
rows (0 or more).

Environment  = Windows XP, perl 5.6 (activestate)
I recently upgraded my DBI module to 1.32
And DBD-Oracle to 1.16
I have an Oracle 9 database on my PC, and have been connecting to it using

I've installed NETDIFF and mysql in FC2 and while running "netdiff --all" am getting the following error.Please help me in this regard.
Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.3/i386-linux-thread-multi /usr/lib/perl5/5.8.3 /usr/lib/perl5/site_perl/5.8 ...

Victor,
Yes, this all makes sense - specifically your find for setting LD_LIBRARY_PATH.  That sentence triggered a recollection for me.  This was the issue I was refering to a few months ago.
As for how to set these vars for the httpd process owner, I think you will need to do this ...

I'm having trouble getting DBI connect to a MySQL 4.1+ server.  I have
to use MySQL's OLD_PASSWORD to set the password on the server in order
for DBI to connect.  This means less secure passwords for MySQL -- 41
byte hashes instead of 45 byte hashes.  Could someone assist in helping

For a given server, dbconnect works in most cases, but fails for a specific userid/pswd. However, using isql I can connect to the server using the userid/pswd that hangs when used in DBI.
Any help greatly appreciated.
Thanks,
Jim

DBI.pm is returning a literal "no error string" in $DBI::errstr after
I attempt to connect to a mssql server.  I've provided source
snippets, dbi trace output, and a patch I've made in an attempt to
more clearly isolate the problem.  As far as I can guess, I think the

I'm getting a strange error regarding an unititialized value at line 545 of
BLK.pm when I try to do a bulk load.  The data actually loads into the
table o.k., and the identity column gets populated o.k. -- so this does not
seem to be a real error.

I've searched and found a few references to the above error, but none
that seems to suit my situation. I wonder if anyone here may have an
idea of what I should look for next...
I have a pretty straightforward setup (I hope!):

I installed ActivPerl 5.8.7 on Windows2000.
While installation of DBI I got these errors dumped:
Error: No valid repositories:
Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error)

Do we need to install Oracle ProC first before we install DBD-Oracle-1.16? I am not sure they post
to the dbi-users.
________________________________
From: Scott T. Hildreth [mailto:shildret@scotth.emsphone.com]

I posted this on the cpanforum.org.  Could you comment??
I am writing a Perl-DBI program to access two Oracle tables that store BFILE
lobs on the filesystem. After getting the lob locator, I plan to get the
directory path and filename from the lob locator, in order to purge the ...

I'm having problems getting any CLI trace info from my Perl script
(which uses DBI and DBD::DB2).  I did:
db2 update cli cfg for section common using trace 1
db2 update cli cfg for section common using traceflush 1