Bug 8560561 - audit TRIGGER RETURNS query instead of contents
Last updated on MARCH 23, 2015
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168. [Release 11.1 to 11.2]
Information in this document applies to any platform.
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.
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)
Unable to implement DML AUDITING in 11g database, which was working fine in 10g
Upgraded to 11g
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