How do you handle exceptions and errors in stored procedures?

Interview Candidate
May 31st, 2005
1
2434

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

onkar

Sep 28th, 2005

exceptions can be handled in various ways in the stored procedures. Method (1) could be using EXCEPTION block in the procedure within which use WHEN <exceptionname> THEN. Method (2) could be declare a variable in DECLARE section as EXCEPTION type, raise it wherever required using RAISE <exception variable name> and handle it in EXCEPTION part using WHEN clause. Method (3) could be using the keywords SQLCODE & SQLERRM to display error no and error code..