Re: Now and then wrong data is inserted in oracle

Jeffrey wrote:

> We are loading data via a Visual Basic program in an oracle database.
> The visual basic program is picking up (scheduled every 10 minutes)
> files from a server and processes the data from the files in the
> oracle database.
> Now and then the data of the files is not inserted correctly in the
> database. Our application is then showing wrong data which frustrates
> our users.
> If we then process the "wrong" file manually via VB then it inserts ok
> in the database.
> Does anyone know what happens?

Sure do. You have badly written code.

How can anyone help you when you provide no version information and not a single line of code. Oracle is obviously not the problem as it seems to work quite well most of the people on the planet so you need to examine you code and trace what it is doing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)