Trigger problem for school project...

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??? When I use a semicolon after end statements, I have the same problem.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 12 2000 - 09:54:39 CST