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?

Sounds like you have a bug in your VB program. Since it works "manually" and the import happens every 10 minutes, I'd bet on a concurrency issue, i.e. your VB program is trying to read from the file at the same time whatever process writes the file is writing. Probably not an Oracle issue, per se.

But as IANAL_VISTA says, not much info to go on here...

-- 
//-Walt
//
//