Stored procedure and variables

[JamieHowarth0]

Hi folks,

Major bugbear - I've just written a stored procedure as part of a challenge-response authentication system in classic ASP and VB. I won't post all my code but basically part of the authentication code is that the user's email address gets posted to my MySQL database server and returns a replication ID as the "challenge" token.

My SP code is as follows:

DELIMITER $$
 
CREATE DEFINER=`admin`@`%` PROCEDURE `NewAuthToken`(IN MyUsername VARCHAR(255), OUT MyNewToken VARCHAR(36))
BEGIN
SET MyNewToken = UUID();
UPDATE tbl_customers SET AuthToken = MyNewToken WHERE tbl_customers.CltEmail = MyUsername;
END $$
 
DELIMITER ;
 

When I try and execute the above code I get the error "OUT or INOUT argument 2 for routine NewAuthToken is not a variable or NEW pseudo-variable in BEFORE trigger". I've tried declaring the variable using DECLARE but then I get an error on that too.

Any ideas?

Many thanks,

medicineworker

[JamieHowarth0]

And it's fixed! Removed the IN and OUT specifications and for variables going OUT, simply passed a null value into the procedure. Challenge-Response in classic ASP accomplished!

If anyone is interested in my code then PM me (cause it involves a Javascript MD5 function, then passing this in and out of two stored procedures, so a couple of different files).

medicineworker