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

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

On Wed, 15 May 2013 22:16:50 +0000, Mladen Gogala wrote:

> Note to myself:
> test this with 11G where alert log is an XML file.

It works:

<msg time='2013-05-15T18:46:47.803-04:00' org_id='oracle' comp_id='rdbms'  client_id='' type='UNKNOWN' level='16'
 host_id='' host_addr='' module=' (TNS V1-V3)'  pid='4217'>
 <txt>Mladen: test write

DBMS_SYSTEM.KSDWRT(2,'....') still writes to the log file, even after the log file became an XML thing.

Mladen Gogala
The Oracle Whisperer
Received on Thu May 16 2013 - 00:50:18 CEST

Original text of this message