Perl to Oracle Connection Error: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET

fattahsafa has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to connect to a remote oracle database in my perl app. When running the app, the following error appears: "Connection Error: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID)" I got Oracle Instant Client and placed it locally then set the Oracle Home env to it, as I don't have Oracle client installed there. My code is below:

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:Oraclehost=$host;sid=$sid;port=$port",
        $userName,
        $passWord
    ) or die "Connection Error: $DBI::errstr\n";
[download]

I'm using ActiveStat perl on Windows Server 2008, ORACLE 10g

Back to Seekers of Perl Wisdom