Stored Procedures help - Mysql 5

[ReTheOff]

Hi all! As always, I aprecieate any help you have.

I know Mysql 5 is alpha right now, but if I can make these sprocs work, they will save me from lots of headaches later. The problem I have is, the CREATE PROCEDURE command always gives me a syntax error. I read the documentation, and I think I've got it right, but if I did, I wouldnt be here asking this question.

So, I started with this:

Create Procedure sp_PlayerList(OUT lm varchar(50) )
BEGIN
Select LastName into lm from tsdata.Players;
End

I get a syntax error. I tried not using the OUT Parameter:

Create Procedure sp_PlayerList()
BEGIN
Select LastName from tsdata.Players;
End

Same thing.

What should I be looking at to fix this? I have the proc table setup in the mysql db. (I know thats required) I dont think this is a permissions thing, as I think I would get a different error. And I have the server setup correctly as far as I can tell (on RH 8), I have a few db's running without any errors right now. (running for almost a month)

Any thoughts?

Thank you.

Greg