APEX

Hi everyone,

I have a text file that contains about 2000 rows of data. I have an sql-loader script that can load the data into an Oracle table. Manually, everything works fine.

Now I want to automate this process using an APEX Application. Here are the steps

1) User will log into this APEX Application
2) I will have a "File Browse" item on a page
3) User will select the file and click Upload.
4) When user clicks "Upload", I want to load the data in the file into an oracle table and please note that "I DO NOT WANT TO USE COLLECTIONS". I have bad experience with collections so lets not discuss collections

Now here is my question

1) Do I have to copy this file over to application server (not local machine) in order for this sql-loader script to work?? or the sql-loader script can work when the file is sitting in the database??

2) How can I call sql-loader in APEX?? I havent done this before and I will appreciate some help with syntax. It would probably be called from a "process"??

Thanks for your help