Re: Certain dynamic sql statements make stored procedures "forget" transaction?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 15 May 2013 22:16:50 +0000 (UTC)
Message-ID: <pan.2013.05.15.22.16.50_at_gmail.com>
On Wed, 15 May 2013 17:29:22 -0400, Gunter Herrmann wrote:
Date: Wed, 15 May 2013 22:16:50 +0000 (UTC)
Message-ID: <pan.2013.05.15.22.16.50_at_gmail.com>
On Wed, 15 May 2013 17:29:22 -0400, Gunter Herrmann wrote:
> Inserts to log files should always be made as an autonomous transaction.
> So that log will never be rolled back.
Or, you can use DBMS_SYSTEM.KSDWRT(2,....) which will make them impossible to roll back, as the destination is not a relational database. I believe it's even cheaper than to write into a table. Note to myself: test this with 11G where alert log is an XML file.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Thu May 16 2013 - 00:16:50 CEST