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

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger created with compilation errors

Re: Trigger created with compilation errors

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Fri, 4 Oct 2002 10:24:07 -0700
Message-ID: <ankiph$387$1@spiney.sierra.com>


shouldn't a trigger like this cause an error?

"Karsten Farell" <kfarrell_at_medimpact.com> wrote in message news:zd_m9.84$AA7.16120996_at_newssvr13.news.prodigy.com...
> iim wrote:
> > what is the problem ??
> >
> > Trigger created with compilation errors
> >
> >
> > create trigger test
> > after insert on test
> > for each row
> > begin
> > end;
> >
> > why this can cause a warning error.
> >
>
> The trigger needs something to do ... even if it's nothing. This will
> compile, but do nothing:
>
> create trigger test
> after insert on test
> for each row
> begin
> null;
> end;
>
Received on Fri Oct 04 2002 - 12:24:07 CDT

Original text of this message

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