Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news.maxwell.syr.edu!news-ge.switch.ch!naxos.belnet.be!news.belnet.be!inf6serv.rug.ac.be!not-for-mail
From: "Axel Hallez" <Axel.Hallez@rug.ac.be>
Newsgroups: comp.databases.oracle.server
Subject: create trigger statement in sqlplus
Date: Wed, 10 Oct 2001 10:07:32 +0200
Organization: University of Ghent, Belgium
Lines: 25
Message-ID: <9q0vl9$bm8$1@inf6serv.rug.ac.be>
NNTP-Posting-Host: beaker.rug.ac.be
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Xref: easynews comp.databases.oracle.server:120770
X-Received-Date: Wed, 10 Oct 2001 04:22:37 MST (news.easynews.com)

Hello all,

I am writing a script to generate a small database which will be used in SQL
exercises.
This script includes some triggers like this:
CREATE TRIGGER "TID_ASSIGN" BEFORE INSERT ON "T_TIJDSCHRIFTEN"
  FOR EACH ROW
  BEGIN
    SELECT TID_SEQ.NEXTVAL INTO :NEW.TID FROM DUAL;
  END;

The problem is that sqlplus does not recognise the end of this statement, so
it remains waiting for the rest of the statement or it reads the rest of the
script as a part of this statement.

Does anybody know a workaround for this problem?

Thanks in advance,

Axel Hallez

Computer Science Laboratory
University of Ghent, Belgium