How to fix the Oracle error PCC-00005: Unsupported datatype in line number of file string?

In this post, you’ll learn more about the Oracle ErrorPCC-00005: Unsupported datatype in line number of file string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00005: Unsupported datatype in line number of file string

Reason for the Error PCC-00005: Unsupported datatype in line number of file string

Cause: A host variable defined in the Declare Section has an unsupported datatype or has a scale or precision outside the supported range.

How to fix the Error PCC-00005: Unsupported datatype in line number of file string ?

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

Action: Redefine the host variable using a supported datatype. Check that the scale and precision of a numeric variable are in the accepted range.