REFRESH_POLICY Procedure

This procedure causes all the cached statements associated with the policy to be reparsed. This guarantees that the latest change to this policy will have immediate effect after the procedure is executed.

The procedure causes the current transaction, if any, to commit before the operation is carried out. However, this does not cause a commit first if it is inside a DDL event trigger.

See Also: Usage Notes

A commit is also performed at the end of the operation.

Syntax

DBMS_RLS.REFRESH_POLICY (
   object_schema IN VARCHAR2 := NULL,
   object_name   IN VARCHAR2 := NULL,
   policy_name   IN VARCHAR2 := NULL); 

Parameters

Table 56-4 REFRESH_POLICY Procedure Parameters

Parameter	Description
object_schema	Schema containing the table or view.
object_name	Name of table or view that the policy is associated with.
policy_name	Name of policy to be refreshed.

Errors

The procedure returns an error if it tries to refresh a disabled policy.