how to compile DBI/DBD

------_=_NextPart_001_01C7672C.7BAB6D1E
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi ,
=20
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.
=20
How can we possibly pass through the error?Howto/Can we recompile
DBI/DBD?
=20
=20
Regards
Praveen

------_=_NextPart_001_01C7672C.7BAB6D1E--

RE: how to compile DBI/DBD

do you know which version of DBD::Oracle you are using and which OS you are
using. There are some known issues that comes up.

Can you send me some test sql as I have some time this week to work on it.


>From: "Praveen Erpineni"
>To:
>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!1 42

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"
>To:
>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!1 42

RE: how to compile DBI/DBD

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=20
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:byterock@hotmail.com]=20
Sent: Thursday, March 15, 2007 10:08 PM
To: Praveen Erpineni; dbi-users@perl.org
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=3D.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 =3D 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"
>To:
>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=20
>our database(10g) using DBI/DBD through a db link created on a 10g=20
>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=20
>is WE8ISO8859P1.
>
>How can we possibly pass through the error?Howto/Can we recompile=20
>DBI/DBD?
>
>
>Regards
>Praveen

____________________________________________________________ _____
Take A Break From The Cold And Have Some Fun Indoors
http://local.live.com/?mkt=3Den-ca/?v=3D2&cid=3DA6D6BDB4586E 357F!142