How do you handle error condition while writing stored procedure or accessing stored procedure from java ?

Correct Answer: Stored procedure should return error code if some operation fails but if stored procedure itself fail than catching SQLException is only choice