Home » RDBMS Server » Server Administration » Auditing lob column changes when working with dbms_lob (oracle10.2, oracle11.1, oracle11.2)
Auditing lob column changes when working with dbms_lob [message #480686] Tue, 26 October 2010 08:19 Go to next message
elutsky
Messages: 10
Registered: July 2010
Junior Member
Hi,

It seems that dml trigger doesn't fire when lob field is being updated using dbms_lob package.

As it stated in Oracle documentation:

Quote:
Using OCI functions or the DBMS_LOB package to update LOB values or LOB attributes of object columns does not cause Oracle to fire triggers defined on the table containing the columns or the attributes.


I need to know that table was updated (or is about to be updated), how can I do that in case it is lob field that is being updated?

Thank you!

Report message to a moderator

Re: Auditing lob column changes when working with dbms_lob [message #480691 is a reply to message #480686] Tue, 26 October 2010 08:33 Go to previous message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you try AUDIT?

If you post a working Test case: create table and insert statements along with the result you want with these data then we will work with your table and data.

Regards
Michel

[Updated on: Tue, 26 October 2010 08:34]

Report message to a moderator

Previous Topic: restore and recover database
Next Topic: managing space
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 17 04:59:28 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.