Re: Before insert trigger failure

In article <96ant5$2qjl$1_at_news5.isdnet.net>, "Yann says...
>
>Hi NG!
>
>I'm trying to write a before insert trigger which allows or not the
>insertion in a table.
>
>What do I write for the failure ? something like
>
>raise no_insert;
>...
>exception
> no_insert
> null;
>....
>
>Or another way ?
>
>Yann
>
>
>

exception when no_insert then
raise_application_error(-20000+ any number,'any descriptive text');

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Feb 13 2001 - 05:29:15 CST