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-16041: Remote File Server fatal error

1 Answers  


KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

1 Answers  


RMAN-06427: recovery catalog already exists

1 Answers  


ORA-31426: cannot modify active subscriptions

1 Answers  


ORA-02822: Invalid block offset

1 Answers  






ORA-00481: LMON process terminated with error

1 Answers  


ORA-24363: measurements in characters illegal here

1 Answers  


ORA-06266: NETNTT: bad write length

1 Answers  


ORA-23361: materialized view "string" does not exist at master site

1 Answers  


ORA-38601: FI Not enough memory for frequent itemset counting: string

1 Answers  


DRG-10701: preference string.string already exists

1 Answers  


O2F-00320: Invalid filename for the OUTTYPE file

1 Answers  


Categories