How to fix the Oracle error PCC-02419: Host variable arrays not allowed in an OBJECT SET or GET?

In this post, you’ll learn more about the Oracle ErrorPCC-02419: Host variable arrays not allowed in an OBJECT SET or GET with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02419: Host variable arrays not allowed in an OBJECT SET or GET

Reason for the Error PCC-02419: Host variable arrays not allowed in an OBJECT SET or GET

Cause: An array was found in the host variable list of an OBJECT SET or GET statement.

How to fix the Error PCC-02419: Host variable arrays not allowed in an OBJECT SET or GET ?

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

Action: Only scalars are allowed (except for single dimensioned char or varchar variables) in the host variable list of an OBJECT SET or GET. Make sure to use only scalars in these statements.