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
Table 19-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;
Parent topic: APEX_DATA_LOADING