Trigger to block insert

From: <dan_beatty_at_my-deja.com>
Date: Wed, 24 Nov 1999 22:18:05 GMT
Message-ID: <81ho6q$g1j$1@nnrp1.deja.com>

Hello,

I would like to write an insert trigger on a table that would block inserts into that table without raising an error. An example of what I'm trying to do follows:

CREATE OR REPLACE TRIGGER my_table_bi
 BEFORE INSERT
    ON my_table
   FOR EACH ROW
BEGIN
  IF <criteria not ok> THEN

• block insert here without raising an error END IF; END;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 16:18:05 CST