Re: Performing UPDATE outside of transaction

Thank you very much!

I forgot to mention that I am running 8i. It looks like dbms_application_info does exactly what I need. If I can't that to work the way I want, I can definitely use and autonomous transaction to do it.

"Richard Kuhler" <noone_at_nowhere.com> wrote in message news:pVYI7.35887$D5.14204817_at_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:25:24 CST