Message-Id: <24715.322465@fatcity.com> From: "Santosh Varma" Date: Thu, 20 Mar 2003 09:10:10 +0530 Subject: RE: Data Capture program it is like this.. i want to create a data capture screen...and put the data in oracle database.. how to proceed with that ?? any solutions... it should not be like the client has to install some other software for this. using available resources itself, the client should be able to capture the details.. it can be through ms access etc. but the database is oracle 8.1.7 -----Original Message----- From: dgoulet@vicr.com [mailto:dgoulet@vicr.com] Sent: Wednesday, March 19, 2003 8:31 PM To: Santosh Varma; Multiple recipients of list ORACLE-L Subject: Re:Data Capture program Santosh, As one who has written a pile of these, you've left out a lot of details. The first question I would have is where is the data coming from and how is it being written. If the data is flat ASCII text, and is from a batch process SQL*Loader or an external table (9i V2) would be appropriate. There are also third party tools available to do the job, Data Junction comes to mind. The only other option would be a custom process. I've done all of the above. SQL*Loader has some limitations that may not make it useful. Data Junction has similar but not identical problems. Custom created processes are the most flexible but can take a while to create depending on what your trying to do. And if the data isn't ASCII text your most likely into custom. Dick Goulet ____________________Reply Separator____________________ Subject: Data Capture program Author: "Santosh Varma" Date: 3/19/2003 3:53 AM Hello list, I am in a project where the client wants a data capture program without any validation in any fields.. the back-end is Oracle 8.1.7. what is the best way to give the user the data capture program ? please provide me any solution as soon as possible. Thanks and regards, Santosh ---------------------------------------------------------------------------- ----

Hello list,
 
     I am in a project where the client wants a data capture program without any validation in any fields..
the back-end is Oracle 8.1.7. what is the best way to give the user the data capture program ?
 
please provide me any solution as soon as possible.
 
Thanks and regards,
 
Santosh