39.6 RESCHEDULE Procedure

This procedure sets the next scheduled execution timestamp of the synchronization.

Syntax

APEX_REST_SOURCE_SYNC.RESCHEDULE (
    p_application_id    IN NUMBER   DEFAULT wwv_flow.g_flow_id,
    p_module_static_id  IN VARCHAR2,
    p_next_run_at       IN timestamp with time zone default systimestamp );

Parameters

Table 39-6 RESCHEDULE Parameters

Parameter Description
p_application_id (Optional): The application ID.
p_module_static_id Static ID to identify the REST Data Source.
p_next_run_at Timestamp to execute the next synchronization.

Example

The following example synchronizes the REST Data Source named "rest_movie" immediately.

BEGIN
    apex_session.create_session(
          p_app_id          => 100,
          p_app_page_id     => 1,
          p_username        => '...' );
 
    apex_rest_source_sync.reschedule(
        p_static_id       => 'rest_movie' );
END;