Leyne, Sean escreveu:

> But in these cases; wouldn't the user want to know/log whether the
> operation was successful (was committed or rolled back)?
>

A committed status/record could be written in the normal transaction.

The ones without this was rolled back.

>
>> 3) Notify events to other processes without lose the transaction
>>
> context.
>
>> A autonomous procedure may update the database and call POST_EVENT.
>> Withing the COMMIT, the events will be delivered.
>>
>
> I don't understand, please elaborate.

Using normal operation of POST_EVENT / COMMIT, one may notify events to
others connections in a SP without waiting for the client to commit the
transaction that called the SP.


Adriano