Hello , I need to download / upload files in my application . However the file sizes sometimes are huge and number of records easily run into millions .
This functionality has to be implemented from the web page i.e. Cannot convert this into a batch job.
However - can someone throw some light / ideas if I think of uploading the file into a tanle in Oracle as a CLOB and then some back end process will pick the file up - parse it and do necessary inserts / updates ?
Could someone throw some light on what the best way to implement would be ?