ORA-28113 Policy Predicate Has Error Even When The VPD Function is Flawless
(Doc ID 782462.1)
Last updated on SEPTEMBER 08, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.
A query running on a table with a VPD function attached keeps failing with ORA-28113, despite the fact that the function does not have any syntactical error.
The syntactically incorrect VPD piece that is reported by the error cannot be found inside the VPD function text, even more, recreating the VPD function (or package) does not solve the problem.
Consider the following scenario:
After fixing the code and replacing SYSCONTEXT with the correct SYS_CONTEXT syntax, the error is still there, even if the package has been syntactically fixed.
Even after dropping the policy, recreating the package and recreating the policy, the error still does not disappear.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document