Oracle 8.1.7 connect

[Jeff Gross]

I have a problem connecting to Oracle 8.1.7 with dbi

I have been using the Perl DBI to connect to Oracle with success until an upgrade to Oracle 8.1.7. Now dbi will not connect unless I have the following environment variable setting

setenv NLS_LANG AMERICAN_AMERICA.US7ASCII

The problem is that I am retrieving Eastern European character from Oracle and some of them are translated into question marks "?". The Oracle database administrator suggested that I use the following env setting

setenv NLS_LANG AMERICAN_AMERICA.EE8ISO8859P2. The problem with this setting is that the DBI connect fails. The error message is

DBI->connect failed: ORA-12705: invalid or unknown NLS parameter value specified (DBD: login failed) at oracle_connect.pl line 10
Unable to connect: ORA-12705: invalid or unknown NLS parameter value specified (DBD: login failed) at oracle_connect.pl line 10.


Thank you for your time and any help is most appreciated.

Jeff Gross

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus