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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to End PL/SQL-Code in SQL

Re: How to End PL/SQL-Code in SQL

From: <cccre.rcastore_at_capital.ge.com>
Date: 1997/12/18
Message-ID: <34986be4.34362411@newsrv.capital.ge.com>#1/1

On Tue, 16 Dec 1997 16:07:07 +0100, Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de> wrote:

>Hallo,
>
>I want to create some triggers out of a file. The Problem is that after
>'CREATE TRIGGER' the whole script belongs to the first trigger.
>What magic sign must I put in the script to make SQL see all CREATE
>TRIGGER staements? As example I would like do run
>the script
>
>CREATE TRIGGER "VERW"."NEWADRTYPID" BEFORE INSERT ON
>"VERW"."VERW_ADRESS_TYPEN_LISTE" REFERENCING OLD AS OLD NEW AS NEW FOR
>EACH ROW WHEN (NEW.ADRTYP_ID IS NULL) BEGIN
> select SEQ_ADRESS_TYPEN_LISTE.NextVal into :new.ADRTYP_ID from dual;
>END;
>
>CREATE TRIGGER "VERW"."NEWADRTYPID2" BEFORE INSERT ON
>"VERW"."VERW_ADRESS_TYPEN_LISTE2" REFERENCING OLD AS OLD NEW AS NEW FOR
>EACH ROW WHEN (NEW.ADRTYP_ID IS NULL) BEGIN
> select SEQ_ADRESS_TYPEN_LISTE2.NextVal into :new.ADRTYP_ID from dual;
>
>END;
>
>Please help me!
>

Put a forward slash "/" after each create statement. Received on Thu Dec 18 1997 - 00:00:00 CST

Original text of this message

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