SQLLoader + APEX Upload

User_C0JD6

Hi

I'm new to Apex and have come across a solution which requires a bit more in depth knowledge than what I have.

I want to be able to create a form which will accept csv files to upload. When the upload finishes, I want to kick off SQL Loader to process that file and load it into tables.

The CSV files could have 2 different structures. So the SQL Loader command being kicked off will be a bit different.

Thanks in advance. I just need to be pointed in the right direction, and then I'll do my reading.

Amit

InoL

That is not how APEX works. When you upload a csv file, you can either use the Data Load Wizard or your own process to parse and load the data in the file using APEX_DATA_PARSER.

https://docs.oracle.com/en/database/oracle/application-express/18/data_load_wizard/

https://oracle-base.com/articles/misc/apex_data_parser#csv

SQLLoader would typically run on the database server to load a file on the database server. I don't think that is what you are looking for.

User_C0JD6

SQLLoader would typically run on the database server to load a file on the database server. I don't think that is what you are looking for.

this is what i was after tbh. Apex accepting the CSV file as an upload to a director and sql loader getting kicked off. But I’m guessing it will have to be a combination of files uploaded to a directory and a continuous daemon checking for new files and the daemon kicking off the sql loader

AndyH

If you don't want to process the file (using APEX_DATA_PARSER, your own CSV processing, etc.) you could write the uploaded blob to the database file system and then access it as an external table.

User_C0JD6

Thank you Andy and Inoll

InoL

Apex accepting the CSV file as an upload to a director and sql loader getting kicked off. 

That seems a bit strange: upload the file to the database (that is what APEX does), write the file to a database directory and then load the file back into the database. I think it is so much easier to skip the part of writing and reading the file from a database directory.

If you really want to do that, I agree with AndyH: access it as an external table, don't use SQLLoader.