please tellme what's wrong with this error.

From: <tim.mcconechy_at_runtime.dk>
Date: Mon, 01 Mar 1999 14:53:34 GMT
Message-ID: <7be9l8$hoo$1@nnrp1.dejanews.com>

ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed Statement Issued: CREATE OR REPLACE TRIGGER numline_audit_info BEFORE INSERT OR UPDATE ON "NUMLINE" FOR EACH ROW BEGIN IF INSERTING THEN :new.user_name := user; :new.lastedit := sysdate; ELSIF UPDATING THEN :new.user_name := user; :new.lastedit := sysdate; END IF; END;

All tables have the same trigger....With the table_name changed but the columns are the same.... I can't see what is wrong here because it works on most other tables... But fails on several tables.

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 08:53:34 CST