From: steveee_ca@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: Trigger problem for school project...
Date: Tue, 12 Dec 2000 18:46:31 GMT
Organization: Deja.com
Lines: 56
Message-ID: <915rq4$rm2$1@nnrp1.deja.com>
References: <915hnr$hr0$1@nnrp1.deja.com>
NNTP-Posting-Host: 209.226.116.84
X-Article-Creation-Date: Tue Dec 12 18:46:31 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
X-Http-Proxy: 1.1 x62.deja.com:80 (Squid/1.1.22) for client 209.226.116.84
X-MyDeja-Info: XMYDJUIDsteveee_ca


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@nnrp1.deja.com>,
  xiekal@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/