NLS_NCHAR_CONV_EXCP

Property	Description
Parameter type	String
Syntax	NLS_NCHAR_CONV_EXCP = { TRUE | FALSE }
Default value	FALSE
Modifiable	ALTER SESSION

NLS_NCHAR_CONV_EXCP determines whether an error is reported when there is data loss during an implicit or explicit character type conversion between NCHAR/NVARCHAR and CHAR/VARCHAR2. The default value results in no error being reported.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘NLS_NCHAR_CONV_EXCP’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
nls_nchar_conv_excp	FALSE	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	NLS raise an exception instead of allowing implicit conversion

Oracle initializatoin parameters