Oracle Error ORA-28132: The MERGE INTO syntax does not support the security policy.

Oracle Error Message

ORA-28132: The MERGE INTO syntax does not support the security policy.

Reason for the Error

The MERGE INTO syntax did not support a security policy on the destination table, because the policy’s statement_types did not include each of INSERT, UPDATE and DELETE.

Solution

If you do not have the privilege to modify the security policy, then instead of MERGE INTO, use the INSERT, UPDATE and DELETE DML statements on the table that has a security policy defined on it. If you have the privilege to modify the security policy, then redefine it in such a way that statement_types includes all of the DML statement types (INSERT, UPDATE and DELETE).

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...