PCC-00097: Use of DECIMAL and DISPLAY types allowed only for
COBOL and PL/I



PCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I..

Answer / guest

Cause: The DECIMAL and DISPLAY external datatype was used in
an EXEC SQL VAR or EXEC SQL TYPE statement with an Oracle
precompiler other than Pro*COBOL or PRO*PL/I. These external
datatypes are available only in Pro*COBOL and PRO*PL/I.

Action: Remove the reference to the DECIMAL or DISPLAY
external datatype from the EXEC SQL TYPE or EXEC SQL VAR
statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers  


ORA-15037: disk 'string' is smaller than mimimum of string MBs

1 Answers  


ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 Answers  


PLS-01464: VARIANCE is not a standard set function

1 Answers  


NNF-04001: Error converting input file

1 Answers  






DRG-12229: special section string already exists in this section group

1 Answers  


RMAN-06002: command not allowed when not connected to a recovery catalog

1 Answers  


ORA-10585: Test recovery can not apply redo that may modify control file

1 Answers  


ORA-08319: sllfsk: Error reading file

1 Answers  


LRM-00107: parameter name abbreviation 'string' is not unique

1 Answers  


ORA-07860: osnsoi: error setting up interrupt handler

1 Answers  


ORA-10651: incorrect file number block number specified

1 Answers  


Categories