Qfyilyi

I keep getting a syntax error while trying to create this procedure to hash a password. Not sure why it says there are syntax errors.

The error I keep getting is:

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 '@pFirstName varchar(255),
@pLastName varchar(255),
@pEmail varchar(255),
@' at line 2

CREATE PROCEDURE `Users`

@pFirstName varchar(255),

@pLastName varchar(255),

@pEmail varchar(255),

@pPassword NVARCHAR(50),

@pType int(11),

@pCreatedAt datetime,

@pUpdatedAt datetime,

@pUser_type enum('admin','project-manager','lawyer','anonymous-client','client','external-client','intake-bot'),

@pUndashPassword NVARCHAR(50),

@responseMessage NVARCHAR(250) OUTPUT



AS

BEGIN

SET NOCOUNT ON



BEGIN TRY



    insert into `Users` (`firstName`,`lastName`,`email`, `password`,`type`,`createdAt`,`updatedAt`,`user_type`, `PasswordHash`)

    VALUES(@pFirstName, @pLastName, @pEmail, @pPassword, @pType, @pCreatedAt, @pUpdatedAt, @pUser_type, HASHBYTES('SHA2_512', @pUndashPassword))



    SET @responseMessage='Success'



END TRY

BEGIN CATCH

    SET @responseMessage=ERROR_MESSAGE() 

END CATCH



END