HELP... need trigger for school proj.

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 Tue Dec 12 2000 - 09:53:04 CST