Re: Rollback commited action?

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 20 Feb 2001 05:15:55 GMT
Message-ID: <3A91FD88.854AA1F3@pro-ns.net>

Marcin Ciesielski wrote:

> Hi everybody
> I have a PL/SQL procedure that performs a commit at the end.
> Is there any way to rollback changes made by that procedure?

No.

>
> Unfortunately I cannot modify source of that procedure.
>
> I have heard about nested transactions, which means that I can have sub
> transaction
> , which changes are commited only when outer transaction commits.
> Is it implemented in ORACLE?

There is a new feature in 8.1, called autonomous transactions. They are nested transactions, but you
can't roll back any commited transaction.

>
>
> Thanks in advance
> Marcin
Received on Mon Feb 19 2001 - 23:15:55 CST