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

RMAN-08108: channel string: specifying block(s) to restore from backup set

1 Answers  


ORA-22958: This operation is not allowed in check constraints or triggers

1 Answers  


ORA-28553: pass-through SQL: invalid bind-variable position

1 Answers  


SQL*Loader-00529: OCI return status: invalid handle

1 Answers  


ORA-00479: RVWR process terminated with error string

1 Answers  






NNL-00209: Cache checkpoint interval is currently string

1 Answers  


ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.

1 Answers  


SQL-02104: Inconsistent host cache. No cursor cache available

1 Answers  


ORA-22332: a dependent object in schema "string" has errors. string

1 Answers  


EXP-00000: Export terminated unsuccessfully

1 Answers  


ORA-40107: operation requires string option to be installed

1 Answers  


DRG-12304: index set string does not exist

1 Answers  


Categories