Error using DECLARE in SPs

[Jon Eversett]

Hi ,

I've trying to compile the examples from the MySQL manual and I am getting error 1064 for every DECLARE statement e.g. DECLARE xid INT;
And get
ERROR 1064 (42000): 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 'DECL
ARE xid INT' at line 1

I'm running version 5.0.13.

Thanks