Toad World® Forums

Unit testing a Trigger


I know you can test functions, procedures, and packages. But is there a way to test a trigger?

thanks much. I’ve attached my trigger.
HMCH1031 -domino doc_20061123_120449.txt (1.22 KB)


You cannot directly test a trigger.

You will need to create a procedure to execute the DML statement that causes the trigger to fire.

Sorry! We will fix this in a future version, but no timetable yet…



Ok so the last time this was addressed was 2008. Its now 2012.

How do we unit test a trigger? I currently have version


It is now 2015 and this is still an issue. If anyone is monitoring, please add my vote for this feature.