Database Error Messages

ORA-22971

invalid data type for PRIMARY KEY based object identifier

Cause

When creating an object view, the data type of an expression in the WITH OBJECT OID clause was not allowed for a PRIMARY KEY based object identifier (OID). Only scalars are allowed here.


Action

Replace the expression with an appropriate scalar data type.