DECLARE t_error INTEGER DEFAULT ;

     DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=;

     START TRANSACTION;    
 7         delete from client;

     IF t_error =  THEN

         ROLLBACK;

     ELSE

         COMMIT;

     END IF;