PCC-01014: "VARYING" not supported with PIC N PICTURE clause



PCC-01014: "VARYING" not supported with PIC N PICTURE clause..

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

ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

1 Answers  


IMG-00840: image structure allocation failed

1 Answers  


ORA-13345: a compound polygon geometry has fewer than five coordinates

1 Answers  


O2F-00337: Schema not found, or no types found in schema

1 Answers  


ORA-31527: could not find source column string for CDC change table string.string

1 Answers  






PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE

1 Answers  


DRG-12602: index owner does not have access to user datastore procedure: string

1 Answers  


EXP-00085: The previous problem occurred when calling string.string.string for object number

1 Answers  


DRG-10202: server failed to register

1 Answers  


ORA-31642: the following SQL statement fails: string

1 Answers  


ORA-01639: instance string has no thread assigned to it

1 Answers  


NNL-00010: error getting address for server "string"

1 Answers  


Categories