Audit trigger for long text column

From: Clifford Buetikofer <clifford_buetikofer_at_merck.com>
Date: Tue, 21 Sep 1999 17:02:11 -0400
Message-ID: <37E7F253.B0E6471F@merck.com>

Kind of a PL/SQL newbie:

I have a very simple table with a number and a long text column. I'm trying to trap update and delete events on the table. The trigger keeps failing when update or delete events are trapped.

I'm just using the standard:

if updating then

	insert into my_audit_table(<col1>,<col2>)
	values (:old.<col1>,:old.<col2>);

end if;

Is there some special PL/SQL functions I should be using ?

TIA,
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 Sep 21 1999 - 16:02:11 CDT