Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can't terminate CREATE TRIGGER command

Can't terminate CREATE TRIGGER command

From: Svend Meyland Nicolaisen <nicolaisen_at_my-deja.com>
Date: Fri, 27 Aug 1999 20:00:23 +0200
Message-ID: <7q6jnm$u1k$1@news.cybercity.dk>


When I enter the following SQL command in SQL*Plus, SQL*Plus just keeps asking for the next line. No matter what I write Oracle doesn't execute the command.

CREATE OR REPLACE TRIGGER DriverTrig
  BEFORE INSERT ON Driver
    FOR EACH ROW
    BEGIN
      SELECT DriverSeq.NEXTVAL INTO :NEW.ID FROM dual;     END; Received on Fri Aug 27 1999 - 13:00:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US