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