Stored routine does not work

[raydona]

Could someone please let me know what is wrong with the following routine.

CREATE PROCEDURE ToVerifyEmployee(IN surname VARCHAR(15),IN email VARCHAR(40),OUT query INT)

BEGIN

DECLARE strA VARCHAR(15);

DECLARE strB VARCHAR(40);

SET strA = '';

SET strB = '';

SELECT LastName, EmailAddress

FROM Employee

INTO strA, strB

IF(strA = surname AND strB = email)

THEN SET query = 1;

ELSE SET query = 0;

END IF;

END;

I get the following error:

#1064 - 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 '' at line 3. I cannot find the error. I'll be grateful for all help.

[Mchl]

Did you change the delimiter to something else than ; before declaring the procedure?

[raydona]

Hi,

  Thanks for the reply. No, I did not change the delimiter to something else than ; before declaring the procedure. I am totally lost as to what might have caused the error.

[Mchl]

Exactly this fact.

 

Use something like this

DELIMITER |
CREATE PROCEDURE ToVerifyEmployee(IN surname VARCHAR(15),IN email VARCHAR(40),OUT query INT)
BEGIN
DECLARE strA VARCHAR(15);
DECLARE strB VARCHAR(40);
SET strA = '';
SET strB = '';
SELECT LastName, EmailAddress
FROM Employee
INTO strA, strB
IF(strA = surname AND strB = email)
THEN SET query = 1;
ELSE SET query = 0;
END IF;
END|