How to fix the Oracle error ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause?

In this post, you’ll learn more about the Oracle ErrorORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

Reason for the Error ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

Attempted to specify a Nested attribute in the WITH OBJECT OID clause.

How to fix the Error ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause ?

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

Specify a top-level attribute of the object type of the object view.