Re: Perl5.8 Oracle DBI connects failing

Looks like DBD::Oracle is not finding the correct OCI files. Have you
updated you Oracle DB or client lately. If so you will have to recompile
DBD::Oracle to run with it.

""Bharathi Masilamani"" <vmbharathi@xxxxxxxxx> wrote in message
news:6a9117130611161921x715151b9hd18d8fbac8ecefd2@xxxxxxxxxxxxxxxxx
Hi,
I am unable to connect to my oracle database I am getting the following
errors..


" DBI connect Failed: connect Failing because of ERROR OCIEnvNlsCreate.
Check ORACLE_HOME env var, NLS settings, permissions, etc."

I stumble into this when I try to execute

"$dbh->selectall_arrayref( $sql )"

I am running Perl5.8 on Red Hat Enterprise Edition 3 and using DBD Oracle
1.17, DBI 1.46 trying to access Oracle 10g

I am not sure which module was compiled against which one..?

any insight into whats happenign here can be great.


Thanks
--

-vmbharathi

I can resist anything but temptation



.

Relevant Pages

  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)
  • RE: (Fwd) DBD:: Oracle Problems
    ... The error is being thrown inside the pl/sql procedure itself not the DBI! ... Subject: DBD:: Oracle Problems ... are receiving the following error when we execute any stored procedures. ... This email has been scanned by the MessageLabs Email Security System. ...
    (perl.dbi.users)
  • Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
    ... If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. ... If you have multiple Oracle installations: set your $ENVusing the ORACLE_HOME with which you compiled your DBD::Oracle. ... If you have multiple perl installations (with DBI, DBD::Oracle) you may have to set the correct path to perl (first line of your script). ...
    (perl.dbi.users)
  • RE: Unix: Oracle User Identified Externally
    ... Subject: Unix: Oracle User Identified Externally ... use DBI; ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)