I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
DBD-Oracle
Posted on 2009-03-13 23:23:55-07 by wmontalvo
Perl DBD::Oracle InstantClient 10.2.0.4.0 on HPUX OCIEnvNlsCreate error
I am building the Perl DBD::Oracle module using InstantClient 10.2.0.4.0 on HPUX 11.11. The build is successful, but the TEST fails with the following error:

t/10general.t ...... DBI connect('','user/pwd@dbname','') failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS \ settings, permissions, etc. at tmp.pl line 12 Error ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, \ permissions, etc. at tmp.pl line 12.

The build and the testing is done as the "oracle" unix account which owns the Oracle RDBMS installation, the perl installation (which was built from scratch) and the instantclient installation.

I have confirmed that the ORACLE_HOME points to the instantclient directory and that the basic, sdk and sqlplus zip files have been unpackaged there.

SQLPLUS does connect properly as
sqlplus user/pwd@dbname

Any idea why the BUILD works, but the TEST fails?

Specs:
======
OS: HPUX 11.11
RDBMS (for TNS_ADMIN and ORA_NLS10) setting: 10gR2
InstantClient: 10.2.0.4.0 (for hp-parisc-32, according to READ it is for HPUX 11.11) (unpackaged by same account)
Perl: 5.8.8 (built from source by same account)
DBI: 1.607 (built from source by same account)
DBD-Oracle: 1.22 (built from source by same account)
ORACLE_HOME=(directory where instantclient was unpackaged) (basic, sdk and sqlplus)
SHLIB_PATH=$ORACLE_HOME
TNS_ADMIN=(tnsadmin directory of RDBMS 10gR2)
ORA_NLS10=(RDBMS oracle_home)/nls/data
Direct Responses: 10227 | Write a response
Posted on 2009-03-19 10:07:50-07 by byterock in response to 10167
Re: Perl DBD::Oracle InstantClient 10.2.0.4.0 on HPUX OCIEnvNlsCreate error
In this case I would say you are missing the .ora files in the instant client directory

By they way no one but me actully look at this list (and I only when I have some spare time)

You would be much better off posting this at http://www.nntp.perl.org/group/perl.dbi.users/ or raise a RT ticket at http://rt.cpan.org/Dist/Display.html?Queue=DBD-Oracle
Direct Responses: Write a response