Citi interview question

How to handle exceptions in stored procedures?