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 -> Re: Performing UPDATE outside of transaction

Re: Performing UPDATE outside of transaction

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 16 Nov 2001 00:16:21 GMT
Message-ID: <pVYI7.35887$D5.14204817@typhoon.san.rr.com>


If you're using 8i or above you can do it with an "autonomous transaction".

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/05_ora.htm#27440

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

Original text of this message

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