My Oracle Support Banner

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 8.1.7.4 to 11.1.0.6 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.