Error al crear procedimiento almacenado
Me pudieran ayudar.
Gracias.
Al crear proc almacena me refiere este error.
No comprendo a que se deba por que este procedimiento me estaba funcionando y al realizar un pequeño cambio en la select final, me comienza a dar.
SQL Error: 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 '' at line 12
Codigo:
CREATE PROCEDURE RequestInsProc
(
IN pEmail varchar(120),
IN pMake varchar(20),
IN pModel varchar(20),
IN pYearModel varchar(20),
IN pPart varchar(20),
IN pVin varchar(40),
IN pCount smallint
)
BEGIN
SET @vId_Client = '0';
SELECT Id_Client INTO @vId_Client FROM client WHERE Email=pEmail;
IF @vId_Client='0'
THEN
SELECT Id_Client INTO @vId_Client FROM users WHERE Email=pEmail;
IF @vId_Client='0'
THEN
CALL UsersInsProc(pEmail);
SELECT Id_Client INTO @vId_Client FROM users WHERE Email=pEmail;
END IF;
END IF;
SET @cons = 0;
SET @cons_var = '';
START TRANSACTION;
INSERT INTO consecutive_request(Type)
VALUES("R");
SELECT MAX(Consecutive) into @cons FROM consecutive_request;
SET @len_cons:=LENGTH(@cons);
WHILE @len_cons < 11 DO
SET @cons = concat("0", @cons);
SET @len_cons:=LENGTH(@cons);
END WHILE;
SET @f=DATE_FORMAT(NOW(), '%d%m%Y');
SET @d=SUBSTRING(@f,1,2);
SET @m=SUBSTRING(@f,3,2);
SET @y=SUBSTRING(@f,5,4);
SET @vId_Request = CONCAT("R", @y, @m, @d, @cons);
SET @vId_Status = 1;
INSERT INTO OrigRequest(Id_Request, Id_Client, Id_Status, Make, Model, YearModel, Part, Vin , Count_Request, Date_Request)
VALUES (@vId_Request, @vId_Client, @vId_Status, pMake, pModel, pYearMOdel, pPart, pVin, pCount, NOW());
COMMIT;
SELECT Id_Request
FROM OrigRequest WHERE Id_Request=@vId_Request;
END;