Hi John, Many Thanks for taking efforts and spending your time for this issue.
Node 1(where the objects earlier stayed) --------------------------------------- NLS_NCHAR_CHARACTERSET UTF8 NLS_CHARACTERSET US7ASCII Node 2(10g Database where the DB Link is Created) ------------------------------------------------- NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_CHARACTERSET US7ASCII Node 3(DB where the objects are being accessed and where the DB Link is pointing to ) ------------------------------------------------------------------------ ------------- NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_CHARACTERSET WE8ISO8859P1 We will also try to use your other steps given. Thanks Again for ur efforts.Appreciate it. Regards Praveen -----Original Message----- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Thursday, March 15, 2007 10:08 PM To: Praveen Erpineni; [email protected] Subject: RE: how to compile DBI/DBD 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
