First question: Is this code is real code or not?
I dot'n' see no any problems with mutating tables.
Then :
because u don't select no 1 row from students table why u need
use techology with BEFORE UPDATE (ROW) trigger and
AFTER UPDATE (STATMENT) trigger and package specification
as "common memory"?

[Edited by Shestakov on 07-16-2002 at 02:23 AM]