Re: Trigger problem for school project...

Hi,

If you're writing the trigger directly in SQL*Plus, type a slash when it gives you an empty line..

  1 create or replace trigger test
  2 before insert on employee
  3 declare
  4 count integer;
  5 begin
  6 count := 0;
  7* end;
SQL> / Trigger created.

You need the semicolon after your variable declaration,after your assignment statement (count := 0;) and after end.

Hope this helps,

Steve

In article <915hnr$hr0$1_at_nnrp1.deja.com>,   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??? When I use a semicolon after end
> statements, I have the same problem.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 12 2000 - 12:46:31 CST