Trigger on a mutating table

robert_177 — Tue, 29 Jul 2003 13:53:56 GMT

Re: Trigger on a mutating table

Yogeeraj_1 — Tue, 29 Jul 2003 21:18:36 GMT

hi,

If you look weel at the error reported by the PLSQL engine, in this part of the code:

IF INSERTING THEN /* Use 'I' for an INSERT, 'D' for DELETE, and 'U' for UPDATE. */
cAuditType := 'I';
cRow_ID = v_Row_ID;
cLast_Upd_By = v_Last_Upd_By;
ELSIF UPDATING THEN
cAuditType := 'U';
cRow_ID = v_Row_ID;
cLast_Upd_By = v_Last_Upd_By;
ELSE
cAuditType := 'D';
cRow_ID = vo_Row_ID;
cLast_Upd_By = vo_Last_Upd_By;
END IF;

You missed the ":" when doing the assignment! :)

should be:
...
cRow_ID := v_Row_ID;
cLast_Upd_By := v_Last_Upd_By;
...

and
...
cRow_ID := vo_Row_ID;
cLast_Upd_By := vo_Last_Upd_By;
...

Cheers
Yogeeraj

topic Re: Trigger on a mutating table in Operating System - HP-UX

Trigger on a mutating table

Re: Trigger on a mutating table