Re: trigger

From: Michel Cadot <micadot_at_francemel.com>
Date: Wed, 18 Aug 1999 14:03:30 +0200
Message-ID: <7pe7fo$1co$1@oceanite.cybercable.fr>

In version 7.3, you can find this information in PL/SQL User's Guide and Reference
Section "Using raise_application_error" (page 6-10).

That is, number must be in the range -20000..-20999.

daud11_at_hotmail.com a écrit dans le message <7pe37m$m6v$1_at_nnrp1.deja.com>...
>Hi All
>
>I would like to create a trigger to do some checking before inserting a
>record. On finding an error I would like to raise an error and prevent
>the record from being saved.
>Question: when I raise the error using
>raise_application_error(<number>, 'Message'), what's the number that I
>can use/what's the range of valid number that I can use?
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Aug 18 1999 - 07:03:30 CDT