Re: Long data type NLS issue

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Sat, 11 Mar 2006 13:30:58 +0100
Message-ID: <00de01c64507$aaa697d0$ae00a8c0@IBME1D11967173>

>I have a 9.2.0.6 DB that was created with AMERICAN US7ASCII character

> set.
> When our heavy PC client inserts into a LONG type column and the number
> of characters is more than 2k we get
> ORA-03106: fatal two-task communication protocol error
>
> If we explicitly set NLS_LANG= AMERICAN_AMERICA.US7ASCII
> Then the client works fine and we can insert up to 32k characters.
>
> We want to do something at the server level (db level) because we can't
> modify the client because we have 100s of clients that would need to be
> modified.

Try to start the listener with the correct NLS env.

Regards,
Dimitre

export NLS_LANG= AMERICAN_AMERICA.US7ASCII lsnrctl start <listener_name>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Mar 11 2006 - 06:30:58 CST