Have you switched the databases? Possibly upgrade the DBD::Oracle as well.
Ilya
-----Original Message-----
From: Robert Bond
To: [EMAIL PROTECTED]
Sent: 2/6/02 11:40 AM
Subject: Help with DBI <***
Hi -
I've been trying to upgrade my version of DBI. My database is Oracle
8.1.7. When I run the test script shown below I get the following error
message:
Error Message:
*************************
DBI->connect(nhup.mccoy) failed: (UNKNOWN OCI STATUS 1804)
OCIInitialize.
Check ORACLE_HOME and NLS settings etc. at test2.pl line 14
I've tried setting the ORACLE_HOME and that doesn't do anything. Has
anyone seen this before? What is OCI status 1804?
Thanks,
Robert
Software Engineer
Script
============================
use DBI;
# Environmental variables used by Oracle
$ENV{ORACLE_SID} = "sid";
$ENV{ORACLE_HOME} = "/oracle/home";
$ENV{EPC_DISABLED} = "TRUE";
$ENV{ORAPIPES} = "V2";
my $dbname = "xxxx";
my $dbuser = "user";
my $dbpass = "passwd";
my $dbh = DBI->connect("dbi:Oracle:$dbname", $dbuser, $dbpass)
|| die "Unale to connect to $dbname: $DBI::errstr\n";
my $sql = qq{ SELECT * FROM dual };
my $sth = $dbh->prepare( $sql );
$sth->execute();
$dbh->disconnect();
+-----------------------------------------------------------------------
-+
Robert S. Bond
email : [EMAIL PROTECTED]
+-----------------------------------------------------------------------
-+
