Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performing UPDATE outside of transaction
If you're using 8i or above you can do it with an "autonomous
transaction".
You might consider just using dbms_application_info though.
Richard
Skippy wrote:
>
> 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 - 18:16:21 CST