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: Pete Sharman <peter.sharman_at_oracle.com>
Date: 3 Oct 2002 08:43:16 -0700
Message-ID: <anhoik0256r@drn.newsguy.com>


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

Original text of this message

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