PCB-00206: Cannot use N quoted literal in PL/SQL when
NLS_LOCAL=YES



PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES..

Answer / guest

Cause: A "N" literal (a literal of the form N'...') was used
within a PL/SQL block when the precompiler option
NLS_LOCAL=YES was used. N literals are not supported in this
situation.

Action: Use an ordinary literal (one without the "N") within
the PL/SQL block or use precompiler option NLS_LOCAL=NO.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00005: INTCTL: error while sending request to the Navigator

1 Answers  


ORA-32807: message system link string already exists

1 Answers  


ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K

1 Answers  


ORA-06257: NETNTT: cannot send command line to shadow process

1 Answers  


ORA-14519: Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]

1 Answers  






PCC-00068: Host and indicator variables may not have the same name.

1 Answers  


ORA-32825: Messaging Gateway agent has not been started

1 Answers  


ORA-07596: sptpa: $GETJPIW failure

1 Answers  


NZE-28764: failure to retrieve a configuration parameter

1 Answers  


ORA-26504: operation not implemented

1 Answers  


ORA-01195: online backup of file string needs more recovery to be consistent

1 Answers  


TNS-12171: TNS:could not resolve connect identifier: string

1 Answers  


Categories