How to fix the Oracle error PCC-00117: Invalid ARRAYLEN length variable type?

In this post, you’ll learn more about the Oracle ErrorPCC-00117: Invalid ARRAYLEN length variable type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00117: Invalid ARRAYLEN length variable type

Reason for the Error PCC-00117: Invalid ARRAYLEN length variable type

Cause: A valid array dimension was not specified in an ARRAYLEN statement. The array dimension must be specified using a previously declared 4-byte integer host variable, not a literal or expression. For example, the offending code might look like: EXEC SQL ARRAYLEN ename_array (25); — illegal dimension

How to fix the Error PCC-00117: Invalid ARRAYLEN length variable type ?

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

Action: Supply a valid array dimension. If necessary, declare a 4-byte integer host variable for use in the ARRAYLEN statement.