Auditing of Long Raw data
From: Clifford Buetikofer <clifford_buetikofer_at_merck.com>
Date: Tue, 13 Apr 1999 14:53:02 -0400
Message-ID: <3713928E.1EA0DF83_at_merck.com>
I've set up some triggers to audit update and delete events but one column is a long raw datatype. I realize regular SQL or PL/SQL can't deal with this datatype but how do I enforce auditing on this column ? I suppose I could execute a PRO*C program from within PL/SQL to somehow retrieve the :OLD and :NEW data but I have zero experience with Pro*C. Are there other solutions ?
Date: Tue, 13 Apr 1999 14:53:02 -0400
Message-ID: <3713928E.1EA0DF83_at_merck.com>
I've set up some triggers to audit update and delete events but one column is a long raw datatype. I realize regular SQL or PL/SQL can't deal with this datatype but how do I enforce auditing on this column ? I suppose I could execute a PRO*C program from within PL/SQL to somehow retrieve the :OLD and :NEW data but I have zero experience with Pro*C. Are there other solutions ?
Lost in Pennsylvania,
Cliff
The contents of this message express only the sender's opinion. This message does not necessarily reflect the policy or views of my employer, Merck & Co., Inc. All responsibility for the statements made in this Usenet posting resides solely and completely with the sender.Received on Tue Apr 13 1999 - 20:53:02 CEST