Re: Certain dynamic sql statements make stored procedures "forget" transaction?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 15 May 2013 22:50:18 +0000 (UTC)
Message-ID: <pan.2013.05.15.22.50.18_at_gmail.com>
On Wed, 15 May 2013 22:16:50 +0000, Mladen Gogala wrote:
Date: Wed, 15 May 2013 22:50:18 +0000 (UTC)
Message-ID: <pan.2013.05.15.22.50.18_at_gmail.com>
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='oradb.home.com' host_addr='192.168.1.181'
module='sqlplus_at_oradb.home.com (TNS V1-V3)'
pid='4217'>
<txt>Mladen: test write
</txt>
</msg>
DBMS_SYSTEM.KSDWRT(2,'....') still writes to the log file, even after the log file became an XML thing.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Thu May 16 2013 - 00:50:18 CEST