Re: Strange Problem
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 07:38:08 -0700
Arghadeep,
It would be much more useful if you posted the PL/SQL code in question along
with your brief description. Your description by itself is far too vague.
We¹re willing to help, but you¹ve got to meet us halfway...
-Tim
on 3/25/04 7:10 AM, Arghadeep Chatterjee at dba@xxxxxxxxxxx wrote:
> Hi All,
> I am facing a strange problem the details of which is given below
> Hp-UX 11.11,Oracle 9.2.0.1.0
> Users arnd 213
> Mem 4GB
> Proc 2
> Type of application Custom ERP using Oracle Forms and Reports 6i
> Now the problem
> from one of the forms an Oracle DB procedure is called say x
> this procedure creates a curson say y
> now it goes on updating three tables say row 1,2,3 .The strange thing is
> while working at some times this application inserts the three rows for the
> say first table and compleletely misses to update the same value to another
> table say row 2 and 3 while it updates row 1.I am unable to find a logical
> reason for
> this as commit is issued at the end of the procedure and at certain times it
> just
> works as it is intended to work.Any pointers anyone.
> Thanks
> Deep
>
Other related posts:
