How to fix the Oracle error PCC-02367: This indicator variable must be declared as type short?

In this post, you’ll learn more about the Oracle ErrorPCC-02367: This indicator variable must be declared as type short with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02367: This indicator variable must be declared as type short

Reason for the Error PCC-02367: This indicator variable must be declared as type short

Cause: An indicator for a host variable of this type must have the C type short. An array of such indicators must be an array of shorts.

How to fix the Error PCC-02367: This indicator variable must be declared as type short ?

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

Action: Declare the indicator variable or indicator array as type short.