Skip navigation links

MySQL Forums :: Stored Procedures :: Create function gets error no matter what


Advanced Search

Create function gets error no matter what
Posted by: Joel Carlson ()
Date: August 26, 2013 12:58PM

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.

Options: ReplyQuote


Subject Views Written By Posted
Create function gets error no matter what 814 Joel Carlson 08/26/2013 12:58PM
Re: Create function gets error no matter what 377 Joel Carlson 08/26/2013 01:33PM
Re: Create function gets error no matter what 398 Joel Carlson 08/26/2013 02:20PM
Re: Create function gets error no matter what 359 Peter Brawley 09/01/2013 08:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.