Trigger Problems

I am getting an error that I just can't find. MGR-00072: Warning: TRIGGER TEMP_T_TRIGSEQ created with compilation errors. The following is the code and I would appreciate any thoughts. Thanks ... Gene Berger

DROP TABLE POS_Temp_T;
CREATE TABLE POS_Temp_T (
id_SEQ Number(10),
BRANCH_CODE VarChar(2),
BUSINESS_UNIT_CODE VarChar(2),
COUNTRY_CODE VarChar(2),
CUST_NAME VarChar(30),
MFG VarChar(3),
MONTHLY_SHIP_QTY Numeric(10),
PARENT_MFG_CD VarChar(3),
PART_NO VarChar(20),
PROCESS_MONTH Numeric(6),
SELL_PRICE Numeric(10,2),
SLS_ANAL_BRANCH_CODE VarChar(2),
STATE_CODE VarChar(2),
ZIP VarChar(10),
ITEM_DESCR VarChar(40)
);

DROP SEQUENCE POS_Temp_T_SEQ;
CREATE SEQUENCE POS_Temp_T_SEQ INCREMENT BY 1 START WITH 1;

CREATE OR REPLACE TRIGGER Temp_T_TrigSeq BEFORE INSERT ON POS_Temp_T
  FOR EACH ROW
BEGIN
  SELECT POS_Temp_T_SEQ.nextval
    INTO :new.id_SEQ
    FROM dual;
END; MGR-00072: Warning: TRIGGER TEMP_T_TRIGSEQ created with compilation errors.

 Sent via Deja.com http://www.deja.com/  Before you buy. Received on Thu Jan 27 2000 - 13:00:07 CST