If more than one OrderID is updated at once, your trigger will only capture one of them.  Indeed, I think it would return an error.  Please will you provide table DDL and sample data (CREATE TABLE and INSERT statements), along with an UPDATE statement for which you're having this problem?

John