22.42 PURGE_REST_SOURCE_CACHE Procedure

This procedure purges the local cache for a REST Data Source. The REST Data Source must exist in the current application and be identified by a static ID. If caching is disabled or no cache entries exist, nothing happens.

Syntax

PROCEDURE PURGE_REST_SOURCE_CACHE(
    p_static_id            IN VARCHAR2,
    p_current_session_only IN BOOLEAN DEFAULT FALSE );

Parameters

Table 22-40 PURGE_REST_SOURCE_CACHE Procedure Parameters

Parameter Description

p_static_id

Static ID of the REST Data Source to invoke.

p_current_session_only

Specify true to only purge entries that were saved for the current session. Defaults to false.

Example

Purge cache for the REST Data Source with static ID USGS.

 begin
     apex_exec.purge_rest_source_cache(
         p_static_id => 'USGS' );
 end;