Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger created with compilation errors
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