Database Error Messages

OCI-43586

Cannot create validation directive 'string': ON COMMIT validation directive is not supported since the duality view 'string' does not have a primary key defined on it

Cause

An attempt is being made to create a validation directive with processing stage ON COMMIT on a duality view with no primary keys defined on it.


Action

Ensure that the duality view has identifier fields or use DML time validations such as BEFORE/AFTER OBJECT.