Re: Trigger Problems

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 27 Jan 2000 22:28:12 +0800
Message-ID: <389055FC.4F36@yahoo.com>

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." Received on Thu Jan 27 2000 - 08:28:12 CST