Re: Can't terminate CREATE TRIGGER command

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Fri, 27 Aug 1999 18:26:13 GMT
Message-ID: <37c8d7fb.270006869@inet16.us.oracle.com>

On Fri, 27 Aug 1999 20:00:23 +0200, "Svend Meyland Nicolaisen" <nicolaisen_at_my-deja.com> wrote:

>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;

/
^^^^
You are missing the '/'.

chris.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Aug 27 1999 - 13:26:13 CDT