Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with trigger compilation errors
pdmlog.user_name is declared as NUMBER(2), pdmlog.lastedit is declared as
varchar2(20). There is a type mismatch with what you are trying to store in
these fields.
tim.mcconechy_at_runtime.dk wrote in message
<7ed3ij$ted$1_at_nnrp1.dejanews.com>...
>Hello,
>
>This code usually works fine: CREATE OR REPLACE TRIGGER pdmlog_audit_info
>BEFORE INSERT OR UPDATE ON "PDMLOG" 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; / ERROR
at
>line 2: ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553:
>PLS-320: the declaration of the type of this expression is incomplete or
>malformed
>
>"USER_NAME" number(2) NULL,
>"LASTEDIT" varchar2(20) NULL
Received on Tue Apr 06 1999 - 09:48:06 CDT