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 -> Triggers in SQL plus or toad

Triggers in SQL plus or toad

From: TheRave <mark.deraeve_at_gmail.com>
Date: 28 Oct 2004 06:50:46 -0700
Message-ID: <b20f6574.0410280550.2cf3c245@posting.google.com>


I created a spl script that creates my DB. I run the script with the @ command from my sql plus prompt. At first it consists of only create table and sequence commands. But after I put in create trigger commands it crashes.
When I use / after my triggers, it still doesn't work. Can somebody pls help me?
Here is an example of my script file:

DROP TABLE LA_HARDWARE_DEVICE;
CREATE TABLE LA_HARDWARE_DEVICE (
  LA_HARDWARE_DEVICE_PK NUMBER primary key,

  NAME                   VARCHAR2(20), 
  DESCRIPTION            VARCHAR2(4000) , 
  IP_ADDRESS             VARCHAR2(15),
  COMPORT                VARCHAR2(6), 
  LA_THIN_CLIENT_GUID    VARCHAR2(32) , 
  TYPE                   SMALLINT, 
  USER_STAMP             VARCHAR2(10), 
  LAST_UPDATE            TIMESTAMP, 
  IS_VALID               NUMBER(1,0)

);
DROP SEQUENCE LA_HARDWARE_DEVICE_PK_SEQ; CREATE SEQUENCE LA_HARDWARE_DEVICE_PK_SEQ INCREMENT BY 1
START WITH 1
;

CREATE OR REPLACE TRIGGER LA_HARDWARE_DEVICE_TRIG  BEFORE INSERT ON LA_HARDWARE_DEVICE
 FOR EACH ROW
 BEGIN
 SELECT LA_HARDWARE_DEVICE_PK_SEQ.NEXTVAL  INTO :new.LA_HARDWARE_DEVICE_PK
 FROM DUAL;
 END LA_HARDWARE_DEVICE_TRIG;/ DROP TABLE LA_THIN_CLIENT;
CREATE TABLE LA_THIN_CLIENT (
  LA_THIN_CLIENT_PK NUMBER primary key ,
  GUID	  	     VARCHAR2(32) , 
  NAME               VARCHAR2(20) , 
  DESCRIPTION        VARCHAR2(4000) , 
  IP_ADDRESS         VARCHAR2(15)     , 
  USER_STAMP         VARCHAR2(10)     , 
  LAST_UPDATE        TIMESTAMP         , 
  IS_VALID           NUMBER(1,0)

);
DROP SEQUENCE LA_THIN_CLIENT_PK_SEQ;
CREATE SEQUENCE LA_THIN_CLIENT_PK_SEQ
INCREMENT BY 1
START WITH 1
;

CREATE OR REPLACE TRIGGER LA_THIN_CLIENT_TRIG  BEFORE INSERT ON LA_THIN_CLIENT
 FOR EACH ROW
 BEGIN
 SELECT LA_THIN_CLIENT_PK_SEQ.NEXTVAL
 INTO :new.LA_THIN_CLIENT_PK
 FROM DUAL;
 END LA_THIN_CLIENT_TRIG;/
...

I tried to run it in toad, still doesn' t work, copy pasting the code doesn't work Received on Thu Oct 28 2004 - 08:50:46 CDT

Original text of this message

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