Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!news.mixmin.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: 10.2.0.1 trace uncommitted inserts Date: Fri, 29 Apr 2011 16:30:35 +0000 (UTC) Organization: solani.org Lines: 22 Message-ID: References: <01055700-12ef-4e13-abf8-5446d5328c0b@f31g2000pri.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1304094635 19209 eJwFwQcBADAIAzBNfJAzTv1LWGLi5BPq5mowvMMEaEObPfEExztRVF6Rt3O9nGYtIplZHzl+EYo= (29 Apr 2011 16:30:35 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Fri, 29 Apr 2011 16:30:35 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwQkBwDAIA0BLpRAeObAM/xJ6B3XxL8zhhsWmkFe6Wg8vPAZizfJdxK+dJ0nlGQxTNuoBGnQRNQ== Cancel-Lock: sha1:Ww1unziG9/QzBUDx87rpfV83m4w= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXFGgp5ziF/09YAufmzSAYGMx3TcsMsglXds5haa+pVHQv53OVK/TKUecHBFAQCw== Xref: x330-a1.tempe.blueboxinc.net comp.databases.oracle.server:553 On Thu, 28 Apr 2011 13:08:02 -0700, Tiago wrote: > I have an application written in .net, I have only the .exe, not the > source. It keeps processing data from an external source and inserting > on a table, but sometimes I can't see the data on the table. Sometimes > it inserts, sometimes doesn't. Vendor is taking too long to figure that > out, since the message that get inserted look like exactly like the one > that doesn't :( I suspect it is trying to commit but something wrong > happens. App log doesn't show any error, external data source says it > sent the data correctly, App log says it received, but nothing is > inserted. Now this looks like an intelligent design! There are entities called "triggers" which can be made to fire on insert. Also, the vendor looks like a very competent application producer. Can you reveal us the name of that brilliantly competent software company? The other users need to be warned. -- http://mgogala.byethost5.com