Re: Can I make the trigger to STOP event happening?

From: Cisco <prsingh_at_cisco.com>
Date: 1997/04/05
Message-ID: <01bc415b$15436920$e0d044ab@prsingh-pc.cisco.com>#1/1

Hi
Just fail the trigger .
I do not think that you can stop just one row from inserting. Pratap

Jian Ma <jma007_at_cs.auckland.ac.nz> wrote in article <01bc40e0$a1416240$7021d882_at_jian-ma-pc>...
> I'm trying to write a Oracle 7.3 server trigger.
>
> It's a BEFORE INSERT trigger. The the trigger body, I find that the new
row
> fail to follow the business rule. So I don't want the row to be inserted.
>
> I write a rollback command in the trigger body, but failed to pass the
> compile.
>
> Q: Is it possible that "the egg kill the Hen"?
>
>
>
>
Received on Sat Apr 05 1997 - 00:00:00 CST