How to pass collections to PL/SQL package from OIC

Summary:

We are in the process of transferring all direct table operations (insert/update/delete) from the OIC database activity to a PL/SQL package. However, we are encountering a challenge since OIC does not support the passing of %ROWTYPE variables.

The following documentation says,

The Oracle Autonomous Transaction Processing Adapter uses JDBC drivers to interact with the database and is restricted by JDBC driver constraints. Therefore, nested PL/SQL types ( for example, RECORD types inside a TABLE type) are not supported as IN/OUT parameters in a stored procedure. However, you can define OBJECT types inside the TABLE type.