Re: Trigger created with compilation errors

DROP TRIGGER score_name;
CREATE TRIGGER
 score_name
AFTER
 INSERT
ON
 score
DECLARE
 tmp date
BEGIN
 select sysdate
 into tmp
 from dual;
END;
/

but why i cause a error when i do as above ?

a comilation errors!!!

"Odd Morten Sveås" <odd.morten.sveas_at_accenture.com> ??????:4306a83.0210031230.2c71a026_at_posting.google.com...
> "iim" <lianghs_at_163.net> wrote in message
news:<anhlrt$3fd$2_at_mail.cn99.com>...
> > 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.
>
> There is not alowed in PL/SQL to have a BEGIN END block without any
comands.
> The same goes for then else end if or exception then when end.
>
> create trigger test
> after insert on test
> for each row
> begin
> null;
> end;
>
>
> This will compile fine.
Received on Thu Oct 03 2002 - 22:38:03 CDT