> What is the relationship between an autonomous transaction and its
> parent? If they are independent, the parent won't be able to see the
> results of the autonomous transaction, which is theoretically acceptable
> but likely to cause some serious complaint.

It would be visible to the subsequent autonomous block of code ;)

> With a modest amount of the
> work, the autonomous transaction could be made visible to the parent but
> would still surive rollback of the parent.

Are we really needs such complex behavior ?

> I agree that such a facility would be useful. But I also agree with
> Nando that implementing them programmatically with explicit BEGIN / END
> statements is a more general, flexible, and powerful mechanism than
> declaring a procedure to execute under an autonomous transaction
> allowing, for example, autonomous transactions in loops.

Agree

Regards,
Vlad