Ora-28115: Policy with Check Option Violation
I Am Getting "Ora-28115: Policy with Check Option Violation" While Executing a Stored Procedure. It Specifically Throws Error on an Insert Query Within the Sp...
I am getting "ORA-28115: policy with check option violation" while executing a stored procedure.It specifically throws error on an INSERT query within the SP.With the same request body(data) and same SP,it works in other Enviornment's DB but fails in other one with this error.Can anyone point towards what all can I do to debug and solve the issue ?
1 Answer
Most likely someone has created a VPD policy on this table, which (in this case) means you can only add a row that will ultimately be visible to you based on the policy assigned.
Take a look in xxx_POLICIES to see what has been created.
Docs on DBMS_RLE here
Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.
