Re: Strange Problem
- From: "Arghadeep Chatterjee" <dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Mar 2004 11:52:06 +0530
Hi Daniel,
DO you remember how you solved it?
Deep
----- Original Message -----
From: Daniel Fink
To: oracle-l@xxxxxxxxxxxxx
Sent: Friday, March 26, 2004 2:38 AM
Subject: Re: Strange Problem
Deep,
I can't comment on specifics, but it reminds me of a similar situation.
Periodically, a 3rd party app would 'lose inserts'. Turns out that the
application was not handling errors, so would insert record 1 into table 1 then
insert record 2 into table 2 (but this insert would result in an error that was
not handled by the application) and a commit was issued. So the first insert
was committed and the second was 'lost'.
Turns out a memory corruption was causing the application to send bad data,
Oracle would reject it.
Good luck.
Daniel
Arghadeep Chatterjee wrote:
Hi All,I am facing a strange problem the details of which is given
belowHp-UX 11.11,Oracle 9.2.0.1.0Users arnd 213Mem 4GBProc 2Type of application
Custom ERP using Oracle Forms and Reports 6iNow the problemfrom one of the
forms an Oracle DB procedure is called say xthis procedure creates a curson say
ynow it goes on updating three tables say row 1,2,3 .The strange thing iswhile
working at some times this application inserts the three rows for thesay first
table and compleletely misses to update the same value to anothertable say row
2 and 3 while it updates row 1.I am unable to find a logical reason forthis as
commit is issued at the end of the procedure and at certain times it justworks
as it is intended to work.Any pointers anyone.ThanksDeep
Other related posts:
