PURGE_DUALITY_VIEW_CACHE Procedure

27.60 PURGE_DUALITY_VIEW_CACHE Procedure

Purges the local cache for a Duality View of JSON sources based on REST-enabled SQL. The Duality View or JSON source must exist in the current application and must be identified by its static ID. If caching is disabled or no cache entries exist, nothing happens.

Syntax

APEX_EXEC.PURGE_DUALITY_VIEW_CACHE (
    p_static_id            IN VARCHAR2,
    p_current_session_only IN BOOLEAN DEFAULT FALSE );

Parameters

Parameter	Description
`p_static_id`	Static ID of the JSON or Duality View source.
`p_current_session_only`	Default `FALSE`. Specify `TRUE` to only purge entries that were saved for the current session.

Example

BEGIN
    apex_exec.purge_duality_view_cache(
        p_static_id => '{Duality View static ID}' );
END;

Parent topic: APEX_EXEC