Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: I have a question PL/SQL

Re: I have a question PL/SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 30 Nov 2001 01:06:36 +0100
Message-ID: <u0dk3tobavjt7a@corp.supernews.com>

"Iņaki Irurre" <iirurre_at_pandasoftware.es> wrote in message news:9u506l$rqr$1_at_talia.mad.ttd.net...
> When I create a trigger that stop the execution of a command SQL in case
> that the condition of trigger is fulfilled, the code ( I indicate by xxxx)
> that is sent in the sentence:
>
> RAISE_APPLICATION(-xxxxx, 'mensajeError')
>
> It is always the same number ???
>
> Thanks
>
>
>

You should choose the number yourself and it should be smaller than -20000

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Thu Nov 29 2001 - 18:06:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US