Skip to content

Two triggers, one event

Two BEFORE INSERT triggers exist on the same table. One uppercases code, the other rejects rows whose code is not in a reference table holding uppercase values only.

Rows with lowercase codes are being rejected intermittently across environments. What is the most likely cause?