There are a few people here with Oracle experience that may be able to help but you might get better (or faster) answers on a dedicated Oracle forum rather than a MS SQL Server site.

I worked with Oracle for a year but never wrote a trigger so I am not much help here.