Webmaster Forum / Perl / DBI Library / June 2008

Hi Everyone;
I'm new to this list... Here's what I'm trying to do:
I have a postgresql database running on a Mac G5 tower.  I have a perl
script that is making a ODBC connection to a MSSQL database, extracting a

Hi, I'm running OSX 10.5.3 and I've installed the Oracle instant client.
sqlPlus works just fine and I would have considered by DBD::Oracle  
install to be ok, as well.
I can touch my databases and run simple sql statements on them using  

I am trying to load DBI on a server and getting errors with the make command.
background-----------
DBI 1.604 (building this package)
os = AIX 5300-07

I had posted a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin.
Though those were circumvented successfully, when I try to run a simple script that calls DBI->Connect, I get
DBI connect(....) failed: ERROR OCIEnvNlsCreate. Check ...

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.605.tar.gz
 size: 504313 bytes
  md5: 2d927d5c41dd5775de6a7d0a50093d85
=head2 Changes in DBI 1.605 (svn r11434) 16th June 2008

Thanks for  the response John.  
I just tried  the same thing  on perl 5.10  and had the same results.  
Perl Makefile.PL   and make  output shown below.  
Perl Makefile.PL  looks   ok to me - but I am far from expert,

I'm   having real probs  getting DBD::Oracle  onto  a sphinx  version of
MAC OS ppc.
I have  tried numerous repositories but can't find pre-compiled modules.
If they exist somewhere please can you point me in the right direction.

I'm installing DBD::Oracle 1.20 and I'm getting the following error
from 't/10general.t'.
not ok 1 - system exit 1 should return 256
#     Failed test (t/10general.t at line 45)

I have installed freetds-0.82 successfully to enable installing this
and have configured the connection and it tests OK but when I get to
the DBD:Sybase I run into problems...
with the export of SYBASE=/usr/local the perl Makefile.PL works but

I just ran into this problem...
A stored procedure call like "exec foo ..." was appearing to succeed but
returning no data.
It turned out that the ASE (15.0, which we've recently upgraded to) was

Here's the short version of my question:
Is there a way to have a statement handle cache shared among 2 or more database handles?
And here's the verbose version:
We have an architecture where we have a server with one resident mod_perl process (an Apache child) that serves requests ...

I have been doing a little research into connection Pooling with OCI and
I was just wondering if the concept of a "Connection Pool" would fit
into the DBI spec someplace.
As we already have DBI::Apache and "connect_cache"  would it just be

I've installed Perl 5.10 successfully and all other perl program running
perfectly.
But it's showing following problem when i'm trying to connect oracle
Problem:

I'm trying to make a call of packaged stored procedure, e.g.:
=================== perl code ===================
 $sSQL = q{
   begin

Hello. I'm using the fairly standard code structure to process results
with Sybase::CTlib. eg something like this:
   while($dbh->ct_results($restype) == CS_SUCCEED) {
       if($restype == CS_CMD_FAIL) {