Re: Before insert trigger failure

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Tue, 13 Feb 2001 16:04:01 +0100
Message-ID: <96bicn$2m28$1@news4.isdnet.net>

Thanks, that's what I made.
Always a good answer. Bravo.

Yann

postbus_at_sybrandb.demon.nl a écrit dans le message <96b5qb0u74_at_drn.newsguy.com>...
>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 - 09:04:01 CST