Trigger on a mutating table

[Yogeeraj_1]

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