Stored Procedure Woes

[The Collective]

Hello,

Decided (Finally!!!) to start testing out some of the new features 5.x has to offer. More specifically stored procedures and functions.
I have tried to create a procedure but I continue to get an error and I think my syntax is correct.....
Here is the code:
CREATE PROCEDURE usp_GetPermissionGroups
(
IN WebFileName varchar(50),
IN PermGroupID int,
IN Action varchar(10)
)
BEGIN
SELECT * FROM webmanagement_filelist wf
LEFT JOIN webmanagement_groupstofiles wg ON wf.intWebFileID = wg.intWebFileID
WHERE txtWebFileName= WebFileName AND intPermissionGroupID = PermGroupID AND txtActionRequested = Action
END

The SQL statement works fine on it's own and that is not the problem. The error is given for line 8 Which is where the Select statement begins, however
I see no error there. Could someone point me in the right direction with this. It is possible that the rest of my CREATE PROC statement is incorrect.
Any help would be appreciated.

[The Collective]

FYI,

Figured out my own question. Seems like the BEGIN....END block wasn't working correctly. I removed it and it worked. I figured
this out by reading the examples at the bottom of http://dev.mysql.com/doc/mysql/en/CREATE_PROCEDURE.html

The user states:

The problem was that the block within the Procedure was of multiple SQL statements.
To do that, you must surround it within a BEGIN ... END block.

//End

Since I did not have a block of statements I decided to remove the BEGIN...END and everything worked as I expected.


The Collective wrote:

Hello,

Decided (Finally!!!) to start testing out some of the new features 5.x
has to offer. More specifically stored procedures and functions.
I have tried to create a procedure but I continue to get an error and I
think my syntax is correct.....
Here is the code:
CREATE PROCEDURE usp_GetPermissionGroups
(
IN WebFileName varchar(50),
IN PermGroupID int,
IN Action varchar(10)
)
BEGIN
SELECT * FROM webmanagement_filelist wf
LEFT JOIN webmanagement_groupstofiles wg ON wf.intWebFileID =
wg.intWebFileID
WHERE txtWebFileName= WebFileName AND intPermissionGroupID =
PermGroupID AND txtActionRequested = Action
END

The SQL statement works fine on it's own and that is not the problem.
The error is given for line 8 Which is where the Select statement
begins, however
I see no error there. Could someone point me in the right direction with
this. It is possible that the rest of my CREATE PROC statement is
incorrect.
Any help would be appreciated.