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

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

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

Action: Change the item s data type and retry the operation.