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

Index > ORACLE Server Parameters > nls_nchar_conv_excp

nls_nchar_conv_excp


Oracle 11.1.0:

Parameter Name:nls_nchar_conv_excp
Description:NLS raise an exception instead of allowing implicit conversion
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:nls_nchar_conv_excp
Description:NLS raise an exception instead of allowing implicit conversion
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:nls_nchar_conv_excp
Description:NLS raise an exception instead of allowing implicit conversion
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:nls_nchar_conv_excp
Description:NLS raise an exception instead of allowing implicit conversion
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-12713: Character data loss in NCHAR/CHAR conversion
    Cause: When character set conversion happens between CHAR and NCHAR either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.

    Action: Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.

ORA-34719: (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion

    Cause: When character set conversion happens between TEXT and NTEXT either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.

    Action: Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.Note: This message is the OLAP equivalent of ORA-12713.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ nls_nchar_conv_excp ] on the Oracle FAQ.

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