SYNCHRONIZE_DATA Procedure

49.8 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

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_page_id         => 1,
        p_username        => '...' );

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

Parent topic: APEX_REST_SOURCE_SYNC