PCB-00211: VARYING not supported with PIC N or PIC G
variable "string"



PCB-00211: VARYING not supported with PIC N or PIC G variable "string"..

Answer / guest

Cause: The keyword VARYING was used in a PIC N variable
declaration.

Action: Remove the keyword VARYING from the variable
declaration. If you want to declare a PIC N VARCHAR
variable, specify the precompiler option VARCHAR=YES and
declare the variable as an implicit VARCHAR group item as
illustrated by the following example: EXEC SQL BEGIN DECLARE
SECTION END-EXEC. ... 01 ENAME. 05 ENAME-LEN PIC S9(4) COMP.
05 ENAME-ARR PIC N(20). ... EXEC SQL END DECLARE SECTION
END-EXEC.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02079: mv log must have ROWID

1 Answers  


ORA-16095: Dependent destination removal for inactivation

1 Answers  


ORA-31015: Attempted to insert entry without name

1 Answers  


ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

1 Answers  


ORA-30566: Index maintainence clause not allowed for this command

1 Answers  






ORA-13435: GeoRaster metadata dimension inconsistent

1 Answers  


ORA-30649: missing DIRECTORY keyword

1 Answers  


ORA-08234: smsget: cannot get instance listener address

1 Answers  


SQL-02153: Invalid character variable for use in a GET/SET statement

1 Answers  


ORA-26082: load of overlapping segments on table string.string is not allowed

0 Answers  


ORA-31181: PL/SQL DOM handle accesses node that is no longer available

1 Answers  


LSX-00212: value "~1s" whose total digits exceeds ~2d

1 Answers  


Categories