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 .
Update/Insert as part of the handler?
BEGIN Update/Insert END
Outside of the handler?
There are lots of examples in the manuals: