Ah, an Oracle trigger, you would of been best posting that in the "Working with Oracle" section instead as this is primarily a Microsoft SQL Server forum.

Someone with Oracle experience may find this post and help you out, but I don't know Oracle, so I would recommend reading the Oracle Documentation on creating triggers.