Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news2.telebyte.nl!fu-berlin.de!uni-berlin.de!pj28.rce.neoline.com.BR!not-for-mail
From: Tiago Rocha <tiagocrspamtalho@terra.com.br>
Newsgroups: comp.databases.oracle.tools
Subject: Re: problem with a trigger
Date: Fri, 12 Dec 2003 11:09:08 -0300
Lines: 18
Message-ID: <2vijtvga9radnokf4eh86v6j5oss1i3gqo@4ax.com>
References: <%BvBb.69580$oC2.2788492@phobos.telenet-ops.be> <1de5ebe7.0312100514.7aef50ec@posting.google.com> <UpNBb.71428$BP3.2930716@phobos.telenet-ops.be> <1071131818.828907@news.thyssen.com> <3djCb.74080$Pm4.2946156@phobos.telenet-ops.be> <cmgjtv4kg18kktj91uo8kk9b0bv87cb90p@4ax.com> <nwjCb.74112$DX3.2935834@phobos.telenet-ops.be> <7mhjtvocc966qdrkosr98s7nasla6gjp6m@4ax.com> <dPjCb.74132$ev4.2994207@phobos.telenet-ops.be> <qkijtv8l456fn7r0lro3nc7ck89d0n4cfm@4ax.com>
NNTP-Posting-Host: pj28.rce.neoline.com.br (200.199.7.28)
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de 1071237998 1983688 200.199.7.28 ([131164])
X-Newsreader: Forte Free Agent 1.93/32.576 English (American)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:83970

On Fri, 12 Dec 2003 11:08:00 -0300, Tiago Rocha
<tiagocrspamtalho@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