39.7 SYNCHRONIZE_DATA Procedure

This procedure executes the configured data synchronization to the local table. The SYNCHRONIZE_DATA procedure requires an APEX session context.

Syntax

APEX_REST_SOURCE_SYNC.SYNCHRONIZE_DATA (
    p_module_static_id      IN VARCHAR2,
    p_run_in_background     IN BOOLEAN  DEFAULT FALSE,
    p_application_id        IN NUMBER   DEFAULT {current application id} );

Parameters

Table 39-7 SYNCHRONIZE_DATA Parameters

Parameter	Description
p_module_static_id	Static ID to identify the REST Data Source.
p_application_id	(Optional) The application ID.
p_run_in_background	If TRUE, synchronization will run in the background, as a one-time DBMS_SCHEDULER job.
p_application_id	ID of the application containing the REST Data Source.

Example

The following example performs data synchronization immediately, independent of the next scheduled time.

BEGIN
    apex_session.create_session(
        p_app_id          => 100,
        p_app_page_id     => 1,
        p_username        => '...' );

    apex_rest_source_sync.synchronize_data(
        p_module_static_id      => 'rest_movie',
        p_run_in_background     => true );
END;