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

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!

use run command separately (/)

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

-- 
******************************************************************************
AMARENDRA B NETTEM			5039 N E River Road, Apt. 1A
Oracle Certified DBA (OCP)		NORRIDGE, IL 60656
Whittman-Hart Inc., 
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.  

Ph.No. (708) 583 9870 (H)  
       (312) 913 6758 (W)  

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************************
Opinions are mine and do not necessarily reflect those of Whittman-hart
Inc.