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 -> Re: Can't terminate CREATE TRIGGER command

Re: Can't terminate CREATE TRIGGER command

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 27 Aug 1999 20:13:17 +0200
Message-ID: <935777633.27525.0.pluto.d4ee154e@news.demon.nl>


CREATE OR REPLACE TRIGGER DriverTrig
  BEFORE INSERT ON Driver
    FOR EACH ROW
    BEGIN
      SELECT DriverSeq.NEXTVAL INTO :NEW.ID FROM dual;     END;
    / <--

Hth,
Sybrand Bakker, Oracle DBA

Just to make sure the 'arrow' is unnecessary

Svend Meyland Nicolaisen <nicolaisen_at_my-deja.com> wrote in message news:7q6jnm$u1k$1_at_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:13:17 CDT

Original text of this message

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