Environment  = Windows XP, perl 5.6 (activestate)

 

I recently upgraded my DBI module to 1.32

And DBD-Oracle to 1.16

 

I have an Oracle 9 database on my PC, and have been connecting to it using
DBI with no problems.

 

On upgrading to the above versions (I think the prior DBD was 1.12)

My connection no longer works

 

Here is the code which has not changed

# $!perl -w

 

 

use strict;

use DBI;

 

 

DBI->trace(2,"my_trace.txt");

my %attr = (RaiseError => 0, AutoCommit =>1);

my $dbh = DBI->connect("dbi:Oracle:host=127.0.0.1;sid=GAV", 'tdf', 'bike',
\%attr) 

 or die "Failed to connect to database: $DBI::errstr";

my $sth = $dbh->prepare("

      SELECT distinct (owner)

      FROM tdf_results

          " );

$sth->execute();

 

 

 

 

Here is the error

 

 

C:\databases\perl\eg>perl tdftest4.pl

DBI connect('host=127.0.0.1;sid=GAV','tdf',...) failed: ORA-12705: invalid
or unknown NLS parameter

value specified (DBD ERROR: OCISessionBegin) at tdftest4.pl line 10

Failed to connect to database: ORA-12705: invalid or unknown NLS parameter
value specified (DBD ERRO

R: OCISessionBegin) at tdftest4.pl line 10.

 

Is this a known issue, or am I unlucky? Can anyone help, or point me in the
right direction?

 

Thanks

 

Gavin

Reply via email to