How to fix the Oracle error PCC-00132: Indicator array size must not be less than its host variable?

In this post, you’ll learn more about the Oracle ErrorPCC-00132: Indicator array size must not be less than its host variable with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00132: Indicator array size must not be less than its host variable

Reason for the Error PCC-00132: Indicator array size must not be less than its host variable

Cause: An host variable array was used with an indicator array declared with a smaller dimension. For example: EXEC SQL BEGIN DECLARE SECTION; int dept_no[20]; short dept_no_ind[10]; EXEC SQL END DECLARE SECTION; … SELECT … INTO dept_no:dept_no_ind …

How to fix the Error PCC-00132: Indicator array size must not be less than its host variable ?

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

Action: Increase the size of the indicator array.