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: <kennethkoenraadt_at_no-spam.hotmail.com>
Date: Thu, 03 Oct 2002 16:03:04 GMT
Message-ID: <3d9c697f.2397707@news.mobilixnet.dk>


Hi Jim,

Because, unlike many other programming languages, PL/SQL demands a NULL statement to be made explicit :

create trigger test
after insert on test
for each row
begin
NULL; /* <====== */
end;
/

will work.

On Thu, 3 Oct 2002 22:56:24 +0800, "iim" <lianghs_at_163.net> 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.
>
>
Received on Thu Oct 03 2002 - 11:03:04 CDT

Original text of this message

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