Re: Trigger Problems

Connor McDonald wrote:

> Berger, Gene wrote:
> >
> > 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.
>
> Try SHOW ERRORS
>
> or select *
> from user_errors
> where name = <trigger>
>
> HTH
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."

Works for me on 805... no errors returned, I mean.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle Received on Fri Jan 28 2000 - 16:51:04 CST