How to fix the Oracle error PCC-00115: Array required here?

In this post, you’ll learn more about the Oracle ErrorPCC-00115: Array required here with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00115: Array required here

Reason for the Error PCC-00115: Array required here

Cause: In an ARRAYLEN statement, the name of a previously declared host array was not specified. The first host variable in an ARRAYLEN statement must be an array. The second host variable, which specifies an array dimension, must be a 4-byte integer. The correct syntax follows: EXEC SQL ARRAYLEN host_array (dimension); The ARRAYLEN statement must appear in the Declare Section along with, but somewhere after, the declarations of host_array and dimension.

How to fix the Error PCC-00115: Array required here ?

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

Action: Check the spelling of both identifiers in the ARRAYLEN statement. If necessary, supply the missing host array name.