Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger created with compilation errors
In article <anhlrt$3fd$2_at_mail.cn99.com>, "iim" says...
>
>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.
>
>
Probably because there's no statement between the BEGIN and END. You could
simply put the line
null;
in there to make it work. You could also find out fairly simply what's wrong by doing a show errors to see what the errors were.
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Oct 03 2002 - 10:43:16 CDT