false positive error on MESSAGE_TEXT

Answered

This is my code

DECLARE EXIT HANDLER FOR invalid_value
BEGIN
IF castedCompany IS NULL THEN
RESIGNAL
SET MESSAGE_TEXT = 'Invalid Parameter Data Type.'
, MYSQL_ERRNO = 9001;
END IF;
END;

I am getting this error (red underline) on MESSAGE_TEXT

SET expected, got 'MESSAGE_TEXT'

this code runs on the server just fine.

 

 

0

Please sign in to leave a comment.