Re: Strange Problem

From: Arghadeep Chatterjee <dba_at_magma.co.in>
Date: Sat, 27 Mar 2004 12:29:18 +0530
Message-ID: <004d01c413c9$071530c0$4a0710ac@lan.magma.co.in>

Hi,
Thanks man it is solved.
Deep

Original Message ----- From: Powell, Mark D To: 'oracle-l_at_freelists.org' Sent: Thursday, March 25, 2004 7:50 PM Subject: RE: Strange Problem

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 Sat Mar 27 2004 - 00:40:05 CST