Re: Certain dynamic sql statements make stored procedures "forget" transaction?

From: Mladen Gogala <>
Date: Wed, 15 May 2013 22:16:50 +0000 (UTC)
Message-ID: <>

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
Received on Thu May 16 2013 - 00:16:50 CEST

Original text of this message