Bug 8560561 - audit TRIGGER RETURNS query instead of contents (Doc ID 1077396.1)

Last updated on MARCH 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.0. [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

In 11.1 and 11.2 if you have DDL/DML_AUDITING triggers written in PL/SQL, the code which produced the desired result in 10.2.0.4 stopped working in 11.1 and above

There are no errors but you will get something like the following instead of actual statement run.
for example:

SELECT A.SQL_TEXT FROM V$SESSION S,V$SQLAREA A WHERE S.SQL_HASH_VALUE=A.HASH_VALUE AND S.SQL_ADDRESS=A.ADDRESS AND S.SID=:B1

Whereas we should get the result of the above statement, not the statement itself, for example:

INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10)

Business Impact
=============
Unable to implement DML AUDITING in 11g database, which was working fine in 10g

Changes

Upgraded to 11g

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms