PCB-00200: Cannot equivalence PIC N or PIC G variable "string"



PCB-00200: Cannot equivalence PIC N or PIC G variable "string"..

Answer / guest

Cause: A PIC N/G variable, an implicit VARCHAR group item
with a PIC N/G elementary item, or a group item with a PIC
N/G elementary item was used in an EXEC SQL VAR statement.
This is not allowed.

Action: Do not use the PIC N variable in an EXEC SQL VAR
statement. If you want an equivalence to an Oracle type
using an EXEC SQL VAR statement, use a PIC X variable,
instead of a PIC N variable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00173: ~S of ~S type is not a valid restriction of ~S of ~S type

1 Answers  


ORA-25440: invalid table alias: string

1 Answers  


ORA-02770: Total number of blocks is invalid

1 Answers  


ORA-16705: severe internal error in resource guard

1 Answers  


ORA-13300: single point transform error

1 Answers  






PCB-00578: Variable "string" must be a table

1 Answers  


ORA-26523: rpc termination error

1 Answers  


EXP-00017: feature "string" is needed, but not present in database

1 Answers  


NNL-00308: Server dumping its cache to the trace file

1 Answers  


ORA-31217: DBMS_LDAP: PL/SQL - Invalid LDAP newparent.

1 Answers  


QSM-02133: agg(expr) requires correspondng MIN(expr) function

1 Answers  


ORA-29307: datafile string error, string

1 Answers  


Categories