Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Fine Grained Auditing: modify results?

Fine Grained Auditing: modify results?

From: <Stuart_Graham_at_emc.com>
Date: Tue, 20 Jun 2006 05:45:40 -0400
Message-ID: <AEFAD477B2B3AA4E88F26932A06AA2210309FE95@CORPUSMX20B.corp.emc.com>


Is it possible to modify the result set returned by a SELECT statement that is trapped by Fine Grained Auditing? I am using this process to detect when an accessed column is actually archived outside the database, and then calling a stored procedure in the handler to pull the data back. However, the user gets back the results that were obtained BEFORE the restore (i.e. the NULL column value) rather than AFTER; so to get the "real" result a 2nd SELECT has to be performed.

Can this be done?

Oracle 9i / Win2k Professional

Cheers, Graham

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 20 2006 - 04:45:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US