Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Perl - Oracle connection

User468755-OCMay 17 2012 — edited May 17 2012

Hello,

I am staring to work on a perl scripts which will begin by connecting to an oracle db. I have the connection working when connecting to a 10g db, but when I try to connect to an 11g it get the following error:

DBI connect('BDQA','hdb',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at ./test1.pl line 20
ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc.

I have read on the cpan site the following:
"First off you will have to tell DBD::Oracle where the binaries reside for the Oracle client it was compiled against. "

This make sit sound like the client version needs to match the version which DBD:Oracle was compiled against correct?

Does this in turn mean that if we upgrade our client to 11g, my current perl script with the Oracle connection
will no longer work until I install a new DBD:Oracle which was compiled against 11g?

Any help is greatly appreciated.

John

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2012

Added on May 17 2012

#general-database-discussions

6 comments

934 views