How to fix the Oracle error PCC-00092: Length and/or scale incompatible with specified Oracle datatype?

In this post, you’ll learn more about the Oracle ErrorPCC-00092: Length and/or scale incompatible with specified Oracle datatype with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00092: Length and/or scale incompatible with specified Oracle datatype

Reason for the Error PCC-00092: Length and/or scale incompatible with specified Oracle datatype

Cause: An invalid length or scale for an Oracle external datatype in an EXEC SQL TYPE or EXEC SQL VAR statement was specified.

How to fix the Error PCC-00092: Length and/or scale incompatible with specified Oracle datatype ?

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

Action: Check that a length large enough to accommodate the external datatype is specified. If a scale is specified, check that it lies in the range -84..99.