Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:Data Capture program

Re:Data Capture program

From: <dgoulet_at_vicr.com>
Date: Wed, 19 Mar 2003 10:01:11 -0500
Message-Id: <24715.322382@fatcity.com>


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"><!--mail_content--><SPAN id=hotbar_element_used stationery_tag_mark>
<DIV><BR><SPAN class=048554811-19032003></SPAN>Hello&nbsp;list,</DIV>
<DIV>&nbsp;</DIV>
<DIV><SPAN class=048554811-19032003>&nbsp;&nbsp;&nbsp;&nbsp; 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>&nbsp;</DIV>
<DIV><SPAN class=048554811-19032003>please provide me any solution as soon as
possible.</SPAN></DIV>
<DIV>&nbsp;</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>&nbsp;</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&amp;El=hotbar%5felem ent%3bst%3b&amp;SG=&amp;RAND=52766"><IMG title="" alt="Upgrade Your Email - Click here!" src='http://promos.hotbar.com/promos/promodll.dll?GetPromo&amp;El=hotbar%5feleme Received on Wed Mar 19 2003 - 09:01:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US