Posts: 2
Registered: ‎08-11-2020

Writing errors to a table in a stored proc

So I need to build a stored procedure that does a bunch of inserts. I would like to be able to write errors off to some kind of log table. e.g. Single row subquery returns more that one row or duplicate primary key type concerns. I just started learning about Handlers but is that the best way to do this? It seems that they only handle one type of error each.