14.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

Table 14-3 LOAD_DATA 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;