Probably u haven't problem with trigger code.
I have come problems with tables or database instance,
because code like this works perfectly in our applications.