create trigger statement in sqlplus

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 Received on Wed Oct 10 2001 - 03:07:32 CDT