Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP... need trigger for school proj.
xiekal_at_my-deja.com wrote:
> 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.
What you need to do is add a semicolon after END and add a slash (/) on the following line.
Marc
p.s. to get out of editing mode => type a dot (.) Received on Wed Dec 20 2000 - 06:35:48 CST