Oracle Error Message
ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause
Reason for the Error
Attempted to specify a Nested attribute in the WITH OBJECT OID clause.
Solution
Specify a top-level attribute of the object type of the object view.