Error Handling in Stored Procedure

Database
SAP
N/A

Error Handling in Stored Procedure

Hi ,

After this DECLARE EXIT HANDLER FOR SQLEXCEPTION , i need to update a table and insert a value into another table . How can i accomplish this ? Pls help .

Tags (1)
1 REPLY
N/A

Re: Error Handling in Stored Procedure

Update/Insert as part of the handler?

BEGIN Update/Insert END

Outside of the handler?

Nested handlers

There are lots of examples in the manuals:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/SQL_Reference/B035_1148_112A/ch06.152.001.html