Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's a good way to do progress indicators?
You can use the new (relatively) feature AUTONOMOUS_TRANSACTION so that only your progress-log insert/updates are committed. The rest of the process can remain uncommitted until the entire process completes.
Michael Bell <no.spam.mbell_at_highspeed.com> wrote in message
news:skam0qn5h5198_at_corp.supernews.com...
> A long-running PL/SQL procedure needs to make periodic progress
> notifications (without committing). What's a good way to notify client
> programs of progress?
> --Michael
>
>
>
Received on Mon Jun 12 2000 - 00:00:00 CDT
![]() |
![]() |