Oracle Error ORA-22807: cannot resolve to a scalar type or a collection type

Oracle Error Message

ORA-22807: cannot resolve to a scalar type or a collection type

Reason for the Error

Invalid use of a non-scalar (for example, object type) item.

Solution

Change the item’s data type and retry the operation.