Hi, Thanks man it is solved. Deep ----- Original Message ----- From: Powell, Mark D To: 'oracle-l@xxxxxxxxxxxxx' 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Arghadeep Chatterjee Sent: Thursday, March 25, 2004 9:11 AM To: oracle-l@xxxxxxxxxxxxx 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