Re: Strange Problem
- From: "Arghadeep Chatterjee" <dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 27 Mar 2004 11:17:09 +0530
Hi DAniel,
The problem got solved yesterday It seems this Developers forgot to do the null
check for a update clause it was a logical data error.It took me 4 hrs to track
it down but I was well repayed coz I had the chance f taking the hides of this
cats.
Thanks
Deep
----- Original Message -----
From: Daniel Fink
To: oracle-l@xxxxxxxxxxxxx
Sent: Friday, March 26, 2004 8:12 PM
Subject: Re: Strange Problem
Deep,
As it was a 3rd party product, they ended up sending a patch for the
application that solved the problem. I think it was a combination of the fix to
the memory corruption and additional exception handling.
The best way for you to address it is to always handle errors in pl/sql and
never let 'when others' cause a commit.
Daniel
Arghadeep Chatterjee wrote:
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:
