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

ORA-15105: missing or invalid FAILGROUP name

1 Answers  


ORA-14053: illegal attempt to modify string in string statement

1 Answers  


ORA-01988: remote os logon is not allowed

1 Answers  


LFI-00139: Option string cannot be used with option string in calling string.

1 Answers  


ORA-25961: join index prevents dml cascade constraint operation

1 Answers  






ORA-23533: object "string"."string" can not be cached

1 Answers  


DRG-11500: column name expected, found string on line string

1 Answers  


DRG-11534: invalid column string

1 Answers  


ORA-32318: cannot rename a materialized view

1 Answers  


NNL-00805: Queries received, type NAME-SERVER: number

1 Answers  


PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"

1 Answers  


ORA-24320: unable to initialize a mutex

1 Answers  


Categories