if by external application you mean something that connects directly to the databasae without the use of aolserver then yes you probably want to do it via a trigger. if you mean via some other app it will probably be possible via plsql - still recommend looking at the way forums integrates with notifications - because this will tell you what needs to be done via plsql...
