Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-01646: tablespace 'string' is not read only - cannot make read write

1 Answers  


ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

1 Answers  


RMAN-20004: target database name does not match name in recovery catalog

1 Answers  


RMAN-08045: channel string: finished piece string at string with string copies

1 Answers  


ORA-25002: cannot create INSTEAD OF triggers on tables

1 Answers  






ORA-34346: (MXDSS04) The string analytic workspace cannot be detached.

1 Answers  


ORA-26508: null materialized view connection

1 Answers  


ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


PCB-00309: The CONNECT statement is Oracle implementation dependent

1 Answers  


NCR-01007: NCRS: Operation is not supported in a given mode.

1 Answers  


ORA-13411: subset results in null data set

1 Answers  


IMG-00542: contentFormat includes invalid extra information

1 Answers  






Categories