Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Long data type NLS issue

Long data type NLS issue

From: Tony Vecchiet <tony.vecchiet_at_xilinx.com>
Date: Fri, 10 Mar 2006 16:28:56 -0800
Message-ID: <7F6AA92497EEC54EBFD82CD6FE49330A01D600C8@XSJ-EXCHVS1.xlnx.xilinx.com>


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.

Any ideas?

Thanks
tony

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 10 2006 - 18:28:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US