In this post, you’ll learn more about the Oracle ErrorSQL-02152: Invalid numeric variable for use in an array GET/SET statement with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
SQL-02152: Invalid numeric variable for use in an array GET/SET statement
Reason for the Error SQL-02152: Invalid numeric variable for use in an array GET/SET statement
Cause: An host variable with type other than int or short for C or S9(4) or S9(9) binary or comp was used for an exact numeric with and array size > 1.
How to fix the Error SQL-02152: Invalid numeric variable for use in an array GET/SET statement ?
You can fix this error in Oracle by following the below steps
Action: Use only int or short for C or S9(4) or S(9) binary or comp for COBOL when supplying an exact numeric in conjunction with the for clause to indicate arrays. Specifically, display sign leading separate is not allowed in this context.