In article <nTc15.5653$ZZ3.17471_at_typhoon.tampabay.rr.com>,
"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote:
> 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
> >
Autononomous Transactions are an 8.1 feature. For prior versions or as
an alternate you might be able to use the dbms_alert package, to signal
an alert that your other processes are waiting for, or the
dbms_application package, to update the v$session message field for the
other programs to check.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Jun 13 2000 - 00:00:00 CDT
