Hi I have been doing a little work on this so here a few quick sugestions
1) Check and see if there are any patches for Oracle 10 that you have not
applied yet. I know of one patch thatcauses a OCI error that was fixed by a
late patch
2) check the default envionment values for the user that is running DBD. and
see is the NLS_LANG vaue is being set.
3) set the NLS_LANG=.WE8ISO8859P15 values
4) one trick you might want to try is to alter you session to force it to
use a specfic charset. Try this
$dbh->do("alter session set NLS_CHARACTERSET = US7ASCII");
you give me the following values from your DBs
NLS_NCHAR_CHARACTERSET
NLS_CHARACTERSET
for some testing I want to do
From: "Praveen Erpineni" <[EMAIL PROTECTED]>
To: <[email protected]>
Subject: how to compile DBI/DBD
Date: Thu, 15 Mar 2007 14:05:15 -0400
Hi ,
We are getting a character set conversion error while trying to access
our database(10g) using DBI/DBD through a db link created on a 10g
db(where the perl script runs).
The error doesnt occur while we access the database through sqlplus.And
doesnt occur if we change the db link to another 9i db.
The character set on the 9i and the 10g db where the link is created is
US7ASCII and the character set of the db which we are trying to access
is WE8ISO8859P1.
How can we possibly pass through the error?Howto/Can we recompile
DBI/DBD?
Regards
Praveen
_________________________________________________________________
Take A Break From The Cold And Have Some Fun Indoors
http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!142
