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-00345: redo log write error block string count string

1 Answers  


RMAN-06466: error parsing configuration string (string)

1 Answers  


ORA-01776: cannot modify more than one base table through a join view

1 Answers  


PLS-00524: The parameter type in an ORDER method must be the containing object type.

1 Answers  


ORA-12808: cannot set string_INSTANCES greater than number of instances string

1 Answers  


SQL*Loader-00564: illegal hexadecimal literal specified for record delimiter

1 Answers  


ORA-30689: improper value for ORA_DEBUG_JDWP

1 Answers  


ORA-08209: scngrs: SCN not yet initialized

1 Answers  


ORA-01277: file 'string' already exists

1 Answers  


ORA-30443: definition for filter string's item string is invalid

1 Answers  


ORA-38449: table "string" does not exist or is not accessible

1 Answers  


ORA-14507: partition corrupt. all rows do not fall within partition bounds

1 Answers  


Categories