Re: problem with a trigger

"Tiago Rocha" <tiagocrspamtalho_at_terra.com.br> schreef in bericht news:2vijtvga9radnokf4eh86v6j5oss1i3gqo_at_4ax.com...
> 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.net

Thanx for your reply's.
I tried your code but it says, "old., new. are not allowed on table level" but however, I have the solution (thanx to Mark C. Stock), trigger is working just fine now.

Friendly Greetz Received on Fri Dec 12 2003 - 15:39:18 CET