Databases Reference
In-Depth Information
This is all the change that you have to make to the application. Because the predicates
are applied at table level, and not at the statement level, all the queries being
executed against the base tables will get the VPD predicate applied automatically.
What to do when you get a runtime exception
The predicate is dynamically added to the statement, so an error will show up when
you execute the following statement:
SQL> select *
2 from emp
3 /
from emp
*
ERROR at line 2:
ORA-28113: policy predicate has error
The error encountered informs you that there is something wrong with the policy
predicate. The easiest way to determine where the mistake is made is by looking in
the trace ile.
