Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to End PL/SQL-Code in SQL
Put a slash ('/') after the END; statements.
Helmut Hahn 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!
Received on Thu Dec 18 1997 - 00:00:00 CST