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