There is also the V$SESSION_LONGOPS dynamic
views, which became available in slightly earlier versions
of Oracle. Enabled though (I think) the dbms_utility package.
This can't leave an audit trail though as you could with
autonomous transactions, only a 'where am I now' one-liner.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
John Alexander wrote in message
<642A954DD517D411B20C00508BCF23B001255C7C_at_mail.sauder.com>...
>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 Sun Jun 18 2000 - 00:00:00 CDT
