Re: How to Raise Error ?

[William Chiquito]

Hi Roland,

Very good your solution.

That you think of a solution like this:

DELIMITER $$

DROP PROCEDURE IF EXISTS `MyRaiseError`$$

CREATE PROCEDURE `MyRaiseError`(msg VARCHAR(62))
BEGIN
DECLARE Tmsg VARCHAR(80);
SET Tmsg = msg;
IF (CHAR_LENGTH(TRIM(Tmsg)) = 0 OR Tmsg IS NULL) THEN
SET Tmsg = 'ERROR GENERADO';
END IF;
SET Tmsg = CONCAT('@@MyError', Tmsg, '@@MyError');
SET @MyError = CONCAT('INSERT INTO', Tmsg);
PREPARE stmt FROM @MyError;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END$$

DELIMITER ;

mysql> call MyRaiseError('Here error message!');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '@@MyE
rrorHere error message!@@MyError' at line 1

You will always have he himself message of error with the string of error between “@@MyError”. The idea is that soon you clean to the string being single the error message.

It is not the best solution but the declaration of the UDF with the DLL is avoided.

What you think? thanks.