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

ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


DRG-11730: relation does not exist

1 Answers  


ORA-06005: NETASY: dialogue file read failure

1 Answers  


CLSR-01009: database management module failed to start

1 Answers  


ORA-32006: %s initialization parameter has been deprecated

1 Answers  






ORA-26686: cannot capture from specified SCN

1 Answers  


RMAN-06550: clone database not mounted and db_name not set in init.ora

1 Answers  


DRG-12438: document table release failed

1 Answers  


ORA-07624: smsdes: $DGBLSC failure

1 Answers  


ORA-06261: NETNTT: nrange() failed

1 Answers  


ORA-13771: cannot obtain exclusive lock string on "SQL Tuning Set" "string"

1 Answers  


AMD-00109: Parent metadata entity has too many child entities. string "string" has more than string string

1 Answers  


Categories