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

TNS-00131: Missing COMMUNITY in COMMUNITY_COST_LIST in TNSNET.ORA

1 Answers  


ORA-13332: invalid LRS point

1 Answers  


ORA-29356: These parameters can be specified only for directives that refer to consumer groups

1 Answers  


ORA-02185: a token other than WORK follows COMMIT

1 Answers   IBM,


LSX-00117: "minLength" should not be greater than "maxLength"

1 Answers  






TNS-00312: Connection Manager: Failed to get version information

1 Answers  


ORA-22873: primary key not specified for primary key based object table

1 Answers  


PCC-00050: Unable to generate descriptor in program unit ending line number in file string

1 Answers  


PLS-01402: Use of quoted identifier

1 Answers  


TNS-04064: The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.

1 Answers  


ORA-31193: This versioning feature isn't supported for resource string

1 Answers  


ORA-25456: rule set was modified or evaluation terminated for iterator: string

1 Answers  


Categories