How to fix the Oracle error PCC-00090: Precision/scale specification must be given for DECIMAL datatype?

In this post, you’ll learn more about the Oracle ErrorPCC-00090: Precision/scale specification must be given for DECIMAL datatype with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00090: Precision/scale specification must be given for DECIMAL datatype

Reason for the Error PCC-00090: Precision/scale specification must be given for DECIMAL datatype

Cause: A precision and/or scale specification for the Oracle external datatype DECIMAL in an EXEC SQL TYPE or EXEC SQL VAR statement was omitted.

How to fix the Error PCC-00090: Precision/scale specification must be given for DECIMAL datatype ?

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

Action: Add the precision and/or scale specification to the EXEC SQL TYPE or EXEC SQL VAR statement.