Handler for rolling back transactions within a proc

[Jon Vance]

I have created the following procedure as a test case for rolling back transactions using exception handlers. The table "Orders" does exist, and the table "DoesNotExist," shockingly, does not. This drop statement is in there simply to force an error. When I call this procedure, the Orders table is cleared, even though there clearly is an error occurring AND being caught by the handler. Can anyone tell me what I'm missing?

DELIMITER ~

CREATE PROCEDURE TEMP() MODIFIES SQL DATA
BEGIN

DECLARE EXIT HANDLER FOR SQLEXCEPTION,SQLWARNING,NOT FOUND
ROLLBACK;

START TRANSACTION;

DELETE FROM Orders;
DROP TABLE DoesNotExist;

COMMIT;

END~