Re: problem with a trigger
From: Tiago Rocha <tiagocrspamtalho_at_terra.com.br>
Date: Fri, 12 Dec 2003 11:09:08 -0300
Message-ID: <2vijtvga9radnokf4eh86v6j5oss1i3gqo_at_4ax.com>
Date: Fri, 12 Dec 2003 11:09:08 -0300
Message-ID: <2vijtvga9radnokf4eh86v6j5oss1i3gqo_at_4ax.com>
[Quoted] On Fri, 12 Dec 2003 11:08:00 -0300, Tiago Rocha <tiagocrspamtalho_at_terra.com.br> wrote:
>DECLARE
> BEGIN
> IF TO_NUMBER(TO_CHAR(:NEW.RES_DATE,'d')) = 7
> THEN raise_application_error(-20000,'We are closed on sunday');
> END IF;
>END;
ooops, better take that "DECLARE" out...
-- Tiago Rocha Recife - Brasil www.diariodastrilhas.cjb.netReceived on Fri Dec 12 2003 - 15:09:08 CET