APEX

Hi everyone,

I’m currently working on importing more than 800,000 rows of data from an Excel file into an Oracle APEX 21.2 table using Data Load Definitions with the following PL/SQL code:

However, the process is taking too long and loading the screen for an extended period. Has anyone faced similar issues or found a more efficient way to handle large Excel file uploads in Oracle APEX? Any advice on optimizing the process or alternative approaches would be greatly appreciated!

Thanks in advance!

DECLARE
   l_file BLOB;
   l_load_result APEX_DATA_LOADING.T_DATA_LOAD_RESULT;
BEGIN
   SELECT blob_content
   INTO l_file
   FROM apex_application_temp_files
   WHERE name = :P8_FILE;
   
   l_load_result := apex_data_loading.load_data(
       p_application_id  => :APP_ID,
       p_static_id => 'LOAD_DATA',
       p_data_to_load => l_file
   );
END;