Re: Every Attempt at Error Handling Fails with GET statement

[Peter Brawley]

Missing some bits ...

CREATE PROCEDURE routine1()
BEGIN
  DECLARE exit handler for SQLEXCEPTION
    BEGIN
      GET DIAGNOSTICS CONDITION 1
          @sqlstate = RETURNED_SQLSTATE,
          @errno = MYSQL_ERRNO, 
          @text = MESSAGE_TEXT;
      SET @full_error = 
        CONCAT("SQL Exception:act_account_main_create:", @errno, " (", @sqlstate, "): ", @text);
      SELECT @full_error;
    END;
END;