Re: Validate flat file via Oracle

Hi,

What you can do is to upload the flat file to your server via FTP,
load it in Oracle via SQLLoader into a temp table do your validation with a PL/SQL on this table and create an error table.
Get the result from the error's table and get back to the client via http

maybe is because i use pl/sql more often then pro*c or i never use utl_file (don't know if its slow) but i know that SQLLoader is quik, and for you, to go back to the client, i think if you have your result formatted in a table, it will be quick.

hth
Chris
(Sorry for my poor english ;-) )

luke_airig_at_hotmail.com (Luke Airig) wrote in message news:<a066cf23.0201102043.277075fb_at_posting.google.com>...
> 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 Tue Jan 15 2002 - 22:56:23 CET