OraFAQ Forum: Server Administration » Auditing lob column changes when working with dbms

Home » RDBMS Server » Server Administration » Auditing lob column changes when working with dbms_lob (oracle10.2, oracle11.1, oracle11.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Auditing lob column changes when working with dbms_lob [message #480686]

Tue, 26 October 2010 08:19

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

Michel Cadot
Messages: 68758
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 06 09:23:58 CDT 2025