PCB-00207: Invalid use of PIC N or PIC G table variable when
NLS_LOCAL=YES



PCB-00207: Invalid use of PIC N or PIC G table variable when NLS_LOCAL=YES..

Answer / guest

Cause: A PIC N variable was declared using an OCCURS clause.
Tables of PIC N variables are not supported when NLS_LOCAL=YES.

Action: Declare the PIC N variable without an OCCURS clause
or, do not use the PIC N variable in any SQL statements.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28865: SSL connection closed

1 Answers  


ORA-01044: size string of buffer bound to variable exceeds maximum string

1 Answers  


NNL-00989: Objects received with no TTL: number

1 Answers  


ORA-12828: Can't start parallel transaction at a remote site

1 Answers  


ORA-12546: TNS:permission denied

1 Answers  






ORA-31102: Already locked in exclusive mode. Cannot add lock.

1 Answers  


TNS-12534: TNS:operation not supported

1 Answers  


ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

1 Answers  


IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

2 Answers  


ORA-32146: Cannot perform operation on a null date

1 Answers  


ORA-32054: lost communication with FMPUTL process

1 Answers  


PLS-00167: keyword BULK is used in a wrong context

1 Answers  


Categories