I have table BILL and ITEM

CREATE TABLE bill (
in_inv NUMBER PRIMARY KEY,
bill VARCHAR2 (512),
ship VARCHAR2 (512),
invdate DATE,
invno VARCHAR2 (12),
po VARCHAR2 (12),
dn VARCHAR2 (15),
cur VARCHAR2 (15),
pri VARCHAR2 (35),
term VARCHAR2 (30) );

CREATE TABLE item (
in_line NUMBER PRIMARY KEY,
line NUMBER,
invno VARCHAR2 (12),
po1 VARCHAR2 (10),
stock1 VARCHAR2 (2000),
qty1 NUMBER (10),
uom1 VARCHAR2 (5),
pri1 VARCHAR2 (10),
amo1 VARCHAR2 (10),
total VARCHAR2 (10) );

I want in_inv (table BILL)and in_line (table ITEM) can generate AUTO INCREMENT value.

I have try this but get compile error msg.

CREATE TABLE bill
(in_inv NUMBER PRIMARY KEY,
bill VARCHAR2 (512),
ship VARCHAR2 (512),
invdate DATE,
invno VARCHAR2 (12),
po VARCHAR2 (12),
dn VARCHAR2 (15),
cur VARCHAR2 (15),
pri VARCHAR2 (35),
term VARCHAR2 (30) );

CREATE SEQUENCE bill_seq
START WITH 1
INCREMENT BY 1
CACHE 1000;

CREATE OR REPLACE TRIGGER bill_preinsert
BEFORE INSERT ON bill
FOR EACH ROW
BEGIN
SELECT bill_seq.nextval
INTO :new in_inv
FROM dual;
END;


CREATE TABLE item
(in_line NUMBER PRIMARY KEY,
line NUMBER,
invno VARCHAR2 (12),
po1 VARCHAR2 (10),
stock1 VARCHAR2 (2000),
qty1 NUMBER (10),
uom1 VARCHAR2 (5),
pri1 VARCHAR2 (10),
amo1 VARCHAR2 (10),
total VARCHAR2 (10) );

CREATE SEQUENCE item_seq
START WITH 1
INCREMENT BY 1
CACHE 1000;

CREATE OR REPLACE TRIGGER item_preinsert
BEFORE INSERT ON item
FOR EACH ROW
BEGIN
SELECT item_seq.nextval
INTO :new in_line
FROM dual;
END;

Thanks in advance

Can you tell us the error message your getting

It appears that there is a missing period between the :new and the column name in both triggers.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC