in reply to Perl to Oracle Connection Error: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID)
I don't know this is the source of your problem but it looks like you are missing a colon in your DSN. Try adding a colon between Oracle and host.
BEGIN { $ENV{NLS_LANG} = "AMERICAN_AMERICA.UTF8"; $ENV{OCI_NLS_CHARSET_ID} = "AMERICAN_AMERICA.UTF8"; $ENV{ORACLE_HOME} = #The path to the instant Oracle client"; } #Connect to database my $DBHandle = DBI->connect( "dbi:Oracle:host=$host;sid=$sid;port=$port", $userName, $passWord ) or die "Connection Error: $DBI::errstr\n";
|
---|