How to fix the Oracle error PCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I?

In this post, you’ll learn more about the Oracle ErrorPCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error PCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I ?

You can fix this error in Oracle by following the below steps

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