autoinc / counter Field in ORACLE

From: Peter Wilk <PeterWilk_at_compuserve.com>
Date: Sun, 2 Jan 2000 20:29:54 +0100
Message-ID: <84o8lm$9fu$1@ssauraaa-i-1.production.compuserve.com>

hello,
  I want to simulate an AUTOINC field in Oracle with a sequence number using the following code - however I always get a compile-error for the trigger. can anybody help me with that ?
thanks a lot - peter

DROP TABLE SALEADMIN.TEST CASCADE CONSTRAINTS; CREATE TABLE SALEADMIN.TEST
   (

   TESTID               NUMBER(8,0)       NOT NULL,
      CONSTRAINT PK_SUBNUMBERROAD PRIMARY KEY(TESTID),
   TEXT             VARCHAR2(25)      NOT NULL

   )
   TABLESPACE SALEDATA; DROP SEQUENCE SALEADMIN.SEQ_TEST;
CREATE SEQUENCE SALEADMIN.SEQ_TEST

       INCREMENT BY 1 START WITH 1
       MAXVALUE 99999999 MINVALUE 1
       CYCLE CACHE 20 ORDER;

CREATE OR REPLACE TRIGGER SALEADMIN.TRIG_TESTID    BEFORE INSERT ON SALEADMIN.TEST
   BEGIN
      SALEADMIN.TEST.TESTID = SALEADMIN.SEQ_TEST.NEXTVAL;    END; --
Peter Wilk
Assistance and Insurance Consulting
http://ourworld.compuserve.com/homepages/PeterWilk Received on Sun Jan 02 2000 - 13:29:54 CST