Validate flat file via Oracle

I am just learning Oracle and Java and I need some advice on how to approach my latest assignment.

I am working on a Java/Oracle web application and here is the problem that I am trying to solve:

When the user presses the 'validation' button on the web page I need to apply a series of validation tests on each of the fields in a flat file that resides on the user's pc (the client). Any records that fail the validation will then be displayed on the web page with an appropriate error description.

The average flat file size is 6000 records. The validation rules will be in an Oracle table on a UNIX server.

Currently the validation tests are hard-coded in Java, but the processing is much too slow, so we would like to do server-side validation in the hopes that it will run faster.

Right now, I am considering these options:

1. FTP the flat file to the UNIX server and write a PL/SQL package that uses the UTL_FILE package.
2. FTP the flat file to the UNIX server and write a Pro*C program.

Can anyone tell me the pro's and con's of these alternatives or suggest a better approach?

TIA Received on Fri Jan 11 2002 - 05:43:52 CET