How to fix the Oracle error PCC-00024: Indicator variable “string” has wrong type or length at line number in file string?

In this post, you’ll learn more about the Oracle ErrorPCC-00024: Indicator variable “string” has wrong type or length at line number in file string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00024: Indicator variable “string” has wrong type or length at line number in file string

Reason for the Error PCC-00024: Indicator variable “string” has wrong type or length at line number in file string

Cause: An indicator variable was not declared in the Declare Section as a 2-byte integer. Indicator variables must be defined as 2-byte integers.

How to fix the Error PCC-00024: Indicator variable “string” has wrong type or length at line number in file string ?

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

Action: Redefine the indicator variable as a 2-byte integer.