All Forums Database
SAP 73 posts Joined 08/14
07 Oct 2014
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 .

SAP
dnoeth 4628 posts Joined 11/04
08 Oct 2014

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

Dieter

You must sign in to leave a comment.