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 2011-08-18 03:08:44.546508-07 by satyaskrt
DBI connect failed: ERROR OCIEnvNlsCreate
In context to OCIEnvNlsCreate error, Could you please help? perl /tmp/testMDMconnect.pl DBI connect('host=----;port=1521;service_name=MDM152','admindb',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at /tmp/testMDMconnect.pl line 3 Can't call method "prepare" on an undefined value at /tmp/testMDMconnect.pl line 4. /tmp/testMDMconnect.pl contains :
use DBI;>
my $dbh = DBI->connect("dbi:Oracle:host=----;port=1521;service_name=MDM152", "admindb", "admindb");>
my $sth = $dbh->prepare("SELECT sysdate FROM dual");>
my $rv = $sth->execute;>
DBI::dump_results($sth) if $rv;>
$dbh->disconnect;>
After trying much resolving it , have re- installed DBD Oracle and Oracle client too, but again same error. We have DBD:Oracle version 1.26 and Oracle client 11g. Regards, Satya
Direct Responses: Write a response