LOAD_DATA Function Signature 2

19.4 LOAD_DATA Function Signature 2

This function loads CLOB data and returns loading status information containing processed rows and error rows.

Syntax

APEX_DATA_LOADING.LOAD_DATA (
    p_application_id   IN NUMBER      DEFAULT apex_application.g_flow_id,
    p_static_id        IN VARCHAR2,
    p_data_to_load     IN CLOB,
    p_xlsx_sheet_name  IN VARCHAR2    DEFAULT NULL )
    RETURN t_data_load_result;

Parameters

Parameter	Description
`p_application_id`	ID of the application which contains the data load definition.
`p_static_id`	Static ID of the data loading definition to execute.
`p_data_to_load`	CLOB data to be loaded.
`p_xlsx_sheet_name`	For XLSX files, the worksheet to extract.

Example

This example gets data (copy and pasted into the PX_DATA textarea) and executes the my-load-definition data loading definition.

DECLARE
    l_load_result apex_data_loading.t_data_load_result;
BEGIN
    apex_session.create_session( 100, 1, 'ADMIN' );
 
    l_load_result := apex_data_loading.load_data (
                         p_static_id    => 'my-load-definition',
                         p_data_to_load => :PX_DATA );
    dbms_output.put_line( 'Processed ' || l_load_result.processed_rows || ' rows.');
END;

Parent topic: APEX_DATA_LOADING