cancel
Showing results for 
Search instead for 
Did you mean: 

Trigger on a mutating table

robert_177
Occasional Contributor

Trigger on a mutating table

 
what is passat
1 REPLY
Yogeeraj_1
Honored Contributor

Re: Trigger on a mutating table

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)