RE: Strange Problem

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 25 Mar 2004 09:20:28 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA74@USAHM018.amer.corp.eds.com>

Sounds like a data related logic problem. Make sure the procedure logic correctly handles NULL values in any column/variable tested against or in the SQL statement where clauses.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Arghadeep Chatterjee
Sent: Thursday, March 25, 2004 9:11 AM
To: oracle-l_at_freelists.org
Subject: Strange Problem

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:18:28 CST