On Tue, Apr 13, 2010 at 10:43 PM, Alberti Tamas <tom@...> wrote:

>
>
> Hi!
>
> I have a question about transactions. My plan is that a stored procedure
> logs its job in a database table, tought if the client rollback the
> transaction, the log inserts will be also rolled back. Is there any way
> how i can keep some inserts in a transaction? For example i start
> another transaction in the proc or do some inserts outside the
> transaction, what the client initiated?
>
>

Check Autonomous Transactions
http://www.ibsurgeon.com/articles/item122

--
Zaher Dirkey


[Non-text portions of this message have been removed]