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:
- FTP the flat file to the UNIX server and write a PL/SQL package
that uses
the UTL_FILE package.
- 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?