How to fix the Oracle error OCI-22316: input type is not a collection type?

In this post, you’ll learn more about the Oracle ErrorOCI-22316: input type is not a collection type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-22316: input type is not a collection type

Reason for the Error OCI-22316: input type is not a collection type

The user is trying to obtain information for collection types on a non-named collection type.

How to fix the Error OCI-22316: input type is not a collection type ?

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

Use a named collection type for the function.