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-33006: (XSAGDNGL02) The relation workspace object is not related to itself.

1 Answers  


LRM-00107: parameter name abbreviation 'string' is not unique

1 Answers  


ORA-14612: Duplicate lob segment name string for lob column string in template

1 Answers  


ORA-19712: table name exceeds maximum length of string

1 Answers  


ORA-14610: Lob attributes not specified for lob column string for subpartition string

1 Answers  






ORA-00264: no recovery required

1 Answers  


ORA-09813: Unable to get directory status

1 Answers  


NNL-00046: Name string exceeds DN template depth

1 Answers  


ORA-31459: system triggers for DBMS_CDC_PUBLISH package are not installed

1 Answers  


ORA-39501: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  


LPX-00227: entity "~S" is not a parsed entity

1 Answers  


ORA-00470: LGWR process terminated with error

1 Answers  


Categories