Delete trigger help please

From: Sean <dolans_at_my-deja.com>
Date: Thu, 02 Nov 2000 23:41:09 GMT
Message-ID: <8tsu2k$258$1@nnrp1.deja.com>

I am trying to prevent deletion of certain data within a table that is identified with a SYS_PROT flag of 1. With a trigger, I would like to make sure that these fields are never deleted accidently. I can't seem to get it to work. Any help would be greatly appreciated:

DELETEMEA

---

A_ID
A_TEXT
SYS_PROT CREATE OR REPLACE TRIGGER tdDeletemeA BEFORE DELETE ON deletemea FOR EACH ROW
DECLARE
numrows INTEGER;
BEGIN     select count(*) into numrows

      from deletemea
      where
        deletemea.a_id = :old.a_id;

    if (numrows = 0) then
	delete from deletemea where deletemea.a_id = :old.a_id;

    end if;

END;
/

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 02 2000 - 17:41:09 CST