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 -> How to End PL/SQL-Code in SQL

How to End PL/SQL-Code in SQL

From: Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de>
Date: 1997/12/16
Message-ID: <3496991A.8482FF40@bitoek.uni-bayreuth.de>#1/1

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! Received on Tue Dec 16 1997 - 00:00:00 CST

Original text of this message

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