The following is the ORA-22978 error message, you can learn the cause and solution of the Oracle database error.


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

Cause: An attempt was made 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.

Case:

Please wait for the update…