Re: Strange Problem

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 25 Mar 2004 07:38:08 -0700
Message-ID: <BC883CE0.1218E%tim@sagelogix.com>

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_at_magma.co.in 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
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 25 2004 - 08:35:55 CST