39.2 DYNAMIC_SYNCHRONIZE_DATA Procedure

This procedure executes a dynamic data synchronization to the local table based on the provided parameters. The predefined synchronization steps are not executed.

Syntax

APEX_REST_SOURCE_SYNC.DYNAMIC_SYNCHRONIZE_DATA (
    p_module_static_id          IN VARCHAR2,
    --
    p_sync_static_id            IN VARCHAR2,
    p_sync_external_filter_expr IN VARCHAR2               DEFAULT NULL,
    p_sync_parameters           IN apex_exec.t_parameters DEFAULT apex_exec.c_empty_parameters,
    --
    p_application_id            IN NUMBER                 DEFAULT apex_application.g_flow_id );

Parameters

Table 39-2 DYNAMIC_SYNCHRONIZE_DATA Parameters

Parameter	Description
p_module_static_id	Static ID to identify the REST Data Source.
p_sync_static_id	Static ID for this dynamic synchronization.
p_sync_external_filter_expr	External filter expression to use for this synchronization.
p_sync_parameters	REST Data Source parameters to use for this synchronization.
p_application_id	ID of the application containing the REST Data Source.

Example

The following example performs a dynamic data synchronization with Oracle APEX as the REST Data Source's query parameter.

DECLARE
    l_parameters apex_exec.t_parameters;
BEGIN
    apex_exec.add_parameter(
        p_parameters      => l_parameters,
        p_name            => 'query',
        p_value           => 'Oracle APEX' );

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

    apex_rest_source_sync.dynamic_synchronize_data(
        p_module_static_id      => 'rest_movie',
        p_sync_static_id        => 'Sync_Oracle_APEX',
        p_sync_parameters       => l_parameters );
END;