Re: Get the code and description of an error within a stored procedure

[Claudinei Silva]

Peter Brawley / Group

Your idea is even good, but unfortunately I am using the version of MySQL 5.5.20, as I commented in the beginning of my message.
More what I was really looking for would be similar to this but in the version of MySQL 5.5.20 how to do similar to the below, example (1) or (2) ?
Or do when using the commands below, example (3)


1)
GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
@errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
SELECT @sqlstate, @errno, @text;


2)
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
@errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
SELECT @full_error;
END;

3)
MYSQL_ERRNO ou RETURNED_SQLSTATE ou MESSAGE_TEXT