RE: Data Capture program

From: Santosh Varma <vsantosh_at_psi.soft.net>
Date: Thu, 20 Mar 2003 09:10:10 +0530
Message-Id: <24715.322465@fatcity.com>

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_at_vicr.com [mailto:dgoulet_at_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" <vsantosh_at_psi.soft.net> 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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY

style="BACKGROUND-POSITION: right bottom; FONT-WEIGHT: normal; FONT-SIZE: 10pt;
BACKGROUND-IMAGE:
url(http://skins.hotbar.com/skins/mailskins/st/093002/093002us_sunset.jpg); MARGIN: 3px 5px 90px 6px; COLOR: #220000; BACKGROUND-REPEAT: repeat-x; FONT-STYLE: normal; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #ffffff" stationery_tag_mark hbtype="st" ?bgcolor="#ffffff" hmark="hotbar_element" bmark="business_card"><SPAN id=hotbar_element_used stationery_tag_mark>
<DIV><BR><SPAN class=048554811-19032003></SPAN>Hello list,</DIV>
<DIV> </DIV>
<DIV><SPAN class=048554811-19032003>     I am in a
project
where the client wants a data capture program without any validation in any fields..</SPAN></DIV>
<DIV><SPAN class=048554811-19032003>the back-end is Oracle 8.1.7. what is
the
best way to give the user the data capture program ?</SPAN></DIV>
<DIV><SPAN class=048554811-19032003></SPAN> </DIV>
<DIV><SPAN class=048554811-19032003>please provide me any solution as soon
as
possible.</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=048554811-19032003></SPAN><SPAN
class=048554811-19032003></SPAN>T<SPAN class=048554811-19032003>hanks and regards,</SPAN></DIV>
<DIV><SPAN class=048554811-19032003></SPAN> </DIV>
<DIV><SPAN class=048554811-19032003>Santosh</SPAN></DIV>
<DIV><BR></DIV></SPAN>
<DIV id=hotbar_promo><BR>
<HR align=left width="100%" color=gray noShade SIZE=1>
<A

href="http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5f elem
ent%3bst%3b&SG=&RAND=52766"><IMG title="" alt="Upgrade Your Email - Click here!" src='http://promos.hotbar.com/promos/promodll.dll?GetPromo&El=hotbar%5fe Received on Wed Mar 19 2003 - 21:40:10 CST