Re: Trigger created with compilation errors

You are simply missing a ";" :
....
DECLARE
 tmp date; /* <============ HERE */
BEGIN
....

Sake good order : This newsgroup is not a debugging tool.....

• Kenneth Koenraadt

On Fri, 4 Oct 2002 11:38:03 +0800, "iim" <lianghs_at_163.net> wrote:

>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 Fri Oct 04 2002 - 01:38:32 CDT