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.
Please sign in to leave a comment.
Thanks, fixed