MS Access ODBC call to set session variable in MySQL

[David Willemain]

I'm having trouble with my MS Access application that is using ODBC to call a procedure in MySQL (backend database). I want to pass an input parameter to the procedure. That input parameter needs to be assigned to a session variable. I keep getting an error saying expected select, insert, update, or delete command. Here is the MySQL procedure:
BEGIN
-- --------------------------------------------------------------------------------
-- Procedure: sp_CreateUser
-- Description: Create a user on the database
-- --------------------------------------------------------------------------------

SELECT p_User_Id INTO @User_Id;

Any help would be greatly appreciated.