Create function gets error no matter what

[Joel Carlson]

I boiled this down to a a few statements:
CREATE FUNCTION Hierarchy_Agent(value INT)
RETURNS INT
NOT DETERMINISTIC READS SQL DATA
BEGIN
DECLARE xid INT;
END
result:
Error Code: 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 5

line 5 is the declare statement... I think.
What gives? Every source I check verifies correct syntax.
I'm originally SQL Server... only recently beginning with mySQL.
version is '5.1.66-0+squeeze1'



Edited 1 time(s). Last edit at 08/26/2013 01:00PM by Joel Carlson.