Trigger - Close but no cigar?

From: abrusko <abruskoNOfiSPAM_at_binney-smith.com>
Date: Thu, 19 Aug 1999 05:24:16 -0700
Message-ID: <0221c012.ad1722ba@usw-ex0106-048.remarq.com>

Hi,

I'm trying to create a security trigger that will secure one column in a table from any updates or deletions. I think it's close, but it's still coming up with an error message that I can't resolve.

This trigger is:
create or replace trigger secure_freight_columns before delete or update of remit on frt.freight declare
cannot_change EXCEPTION;
begin
raise cannot_change;
EXCEPTION
WHEN cannot_change then

raise_application_error(-12345,'May not CHANGE or DELETE the REMIT column');
end;

The Errors that occur at run time when I change the "remit" column are:

ORA-20324: May not CHANGE or DELETE the REMIT column
ORA-06512: at "ZP29.SECURE_FREIGHT_COLUMNS", line 7
ORA-04088: error during execution of trigger

'ZP29.SECURE_FREIGHT_COLUMNS' Can anyone please tell me what to do to get over the hump with this one...appreciate it greatly!

Andy

Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Thu Aug 19 1999 - 07:24:16 CDT