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

QSM-01080: invalid dimension, string

1 Answers  


PLS-00752: Table function string is in an inconsistent state.

1 Answers  


TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  


ORA-25017: cannot reference NEW ROWID for movable rows in before triggers

1 Answers  


ORA-23608: invalid resolution column "string"

1 Answers  


ORA-14312: Value string already exists in partition string

1 Answers  


ORA-01580: error creating control backup file string

1 Answers  


NPL-00300: maximum ASN.1 element nesting depth string exceeded on read

1 Answers  


LRM-00108: invalid positional parameter value 'string'

1 Answers  


DGM-16944: Failover succeeded. New primary is "string"

1 Answers  


ORA-07263: sptpa: kill error.

1 Answers  


ORA-30745: error occured while trying to add column "string" in table "string"

1 Answers  


Categories