Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Performing UPDATE outside of transaction

Performing UPDATE outside of transaction

From: Skippy <noone_at_nowhere.net>
Date: Thu, 15 Nov 2001 23:36:59 GMT
Message-ID: <vkYI7.453$sA.115516@typhoon.ne.mediaone.net>


Hello everyone,

I have a stored procedure running on Tables A, B, C. It is looping through records, performing INSERTs, UPDATEs, etc. All of this is happening within a transaction, so of course other users get a view of the data as it was before the process started, which is what I want. I also need the ability to rollback the transaction if something fails.

The problem is that I would like to have a status table, call it table D, where I update a field to reflect how many records have been processed. I want this table to be visible to other processes so that other users can see the status of the running process. If I put these updates inside the transaction, the users see no change until the COMMIT.

My question is, is what I want to do possible, and if so, how?

Thanks in advance,

Michael Received on Thu Nov 15 2001 - 17:36:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US