Oracle Error ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

Oracle Error Message

ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

Reason for the Error

When creating an object view, the datatype of an expression in the WITH OBJECT OID clause is not allowed for PRIMARY KEY-based OID.

Solution

Replace the expression with one of appropriate scalar datatype.