Re: HELP... need trigger for school proj.

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 13 Dec 2000 11:46:04 -0000
Message-ID: <917nhr$4b9$1@soap.pipex.net>

you appear to be missing a semicolon after the end statements for a start.

begin
count := 0;
end;
/

The logic of the trigger seems a bit bizarre to me but school projects can be like that.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<xiekal_at_my-deja.com> wrote in message news:915hks$hpk$1_at_nnrp1.deja.com...


> Here are two triggers I am trying to create...

>

> create trigger init_count before insert on pcs

> declare

> count integer;

> begin

> count := 0;

> end

>

>

> create trigger incr_count after insert on pcs

> for each row

> begin

> count := count + 1;

> end

>

> I am using Oracle 8i(personal addition)

>

> When I run either of these, SqlPlus does not do

> anything.

> I cant get out of the editing mode. What I mean

> is, I

> just keep getting line numbers, and cant get out.

> Am I

> missing a semicolon somewhere??? No help when I

> use a semicolon after the END.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Wed Dec 13 2000 - 05:46:04 CST