I'm considering designs for a system that processes batch data files. =
We're thinking of allowing people to upload the data files from a PL/SQL =
Web application, which means that each data file will be initially =
stored in a BLOB column in a "document" table. After a file is =
successfully uploaded, we want to parse the file, edit it, produce =
validation reports, and load valid data into tables.
My initial thought was to store the BLOB column in a file on the server =
(I know how to do this with Java or UTL_FILE), then use SQL*Loader or =
external tables to parse the file and a PL/SQL routine to process the =
data. However, it seems silly to me to export data out of the database, =
just to load it back in again. Do you all have a suggestion for parsing =
the records from a text file stored as a BLOB, with no more coding than =
it would take to write a SQL*Loader control file or a external table =
definition?
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu Feb 19 2004 - 09:40:04 CST
