PCB-00205: Cannot use PIC N or PIC G variable in PL/SQL when
NLS_LOCAL=YES



PCB-00205: Cannot use PIC N or PIC G variable in PL/SQL when NLS_LOCAL=YES..

Answer / guest

Cause: A PIC N or PIC G variable was used in an embedded
PL/SQL block when the precompiler option NLS_LOCAL=YES was
used. A PIC N or PIC G variable is not supported in this
situation.

Action: Do not use the PIC N or PIC G variable 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

ORA-07431: fork failed

1 Answers  


RMAN-06504: PROXY option with multiple backup copies is not supported

1 Answers  


ORA-24313: user already authenticated

1 Answers  


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


PLS-00599: SAMPLE percentage must be in the range [0.000001,100)

1 Answers  






NID-00304: Datafile string - reverted

1 Answers  


ORA-13230: failed to create temporary table [string] during R-tree creation

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


ORA-16528: unable to allocate PGA heap

1 Answers  


ORA-02270: no matching unique or primary key for this column-list

5 Answers  


NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded

1 Answers  


SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

1 Answers  


Categories