How to fix the Oracle error PCC-01018: Conversion buffer size can only be specified for character types?

In this post, you’ll learn more about the Oracle ErrorPCC-01018: Conversion buffer size can only be specified for character types with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-01018: Conversion buffer size can only be specified for character types

Reason for the Error PCC-01018: Conversion buffer size can only be specified for character types

Cause: A CONVBUFSZ clause has been used in an EXEC SQL VAR statement where the variable is not of a character datatype.

How to fix the Error PCC-01018: Conversion buffer size can only be specified for character types ?

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

Action: Remove the CONVBUFSZ clause from the EXEC SQL VAR statement.