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

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

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...