[SOLUCIONADO] Error creando Stored Procedure

[mauritosuarez]

Hola gente del foro, estoy tratando de crear un Stored Procedure que me pasaron para implementar en pre-producción, utilizo Workbench pero me arroja error, alguien me podría indicar donde puede estar el error.

Versión de MySql 5.6

Stored Procedure

Código MySQL:

CREATE PROCEDURE `limite_dnr_nuevo` (IN tu INT, OUT nuevodr INT)
NOT DETERMINISTIC
CONTAINS SQL
BEGIN
DECLARE top INT;
DECLARE dr INT;
DECLARE incrementa INT;
DECLARE lastdr INT;
DECLARE toplimit INT;
SELECT tope INTO top FROM devriver_dnr where id = tu;
SELECT dnr INTO dr FROM devriver_dnr where id = tu;
SET lastdr = (select dr) ;
SET toplimit = (select top);
IF tu = 1 THEN
    IF lastdr > toplimit THEN   
        SELECT dnr INTO dr FROM devriver_dnr where id = 2;
        SET lastdr = (select dr) ;
        
        SET incrementa = lastdr + 1;
        UPDATE devriver_dnr SET dnr = incrementa WHERE id = 2;
        SELECT incrementa;
    else
        SELECT dnr INTO dr FROM devriver_dnr where id = tu;
        SET lastdr = (select dr) ;
        SET incrementa = lastdr + 1;
        UPDATE devriver_dnr SET dnr = incrementa WHERE id = tu;
        SELECT incrementa;
    END IF;
else
        SELECT dnr INTO dr FROM devriver_dnr where id = tu;
        SET lastdr = (select dr) ;
        SET incrementa = lastdr + 1;
        UPDATE devriver_dnr SET dnr = incrementa WHERE id = tu;
        SELECT incrementa;
END IF;
 
SET nuevodr = incrementa;
END
 

Error que devuelve

mysql> use vamosriver
No connection. Trying to reconnect...
Connection id: 593723
Current database: *** NONE ***

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> \. /home/mysql/Descargas/procedureDR.sql
ERROR 1064 (42000): 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 5
ERROR 1064 (42000): 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 'DECLARE dr INT' at line 1
ERROR 1064 (42000): 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 'DECLARE incrementa INT' at line 1
ERROR 1064 (42000): 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 'DECLARE lastdr INT' at line 1
ERROR 1064 (42000): 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 'DECLARE toplimit INT' at line 1
ERROR 1327 (42000): Undeclared variable: top
ERROR 1327 (42000): Undeclared variable: dr
ERROR 1193 (HY000): Unknown system variable 'lastdr'
ERROR 1193 (HY000): Unknown system variable 'toplimit'
ERROR 1064 (42000): 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 'IF tu = 1 THEN
IF lastdr > toplimit THEN
SELECT dnr INTO dr FROM devriver_dn' at line 1
ERROR 1193 (HY000): Unknown system variable 'lastdr'
ERROR 1193 (HY000): Unknown system variable 'incrementa'
ERROR 1054 (42S22): Unknown column 'incrementa' in 'field list'
ERROR 1054 (42S22): Unknown column 'incrementa' in 'field list'
ERROR 1064 (42000): 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 'else
SELECT dnr INTO dr FROM devriver_dnr where id = tu' at line 1
ERROR 1193 (HY000): Unknown system variable 'lastdr'
ERROR 1193 (HY000): Unknown system variable 'incrementa'
ERROR 1054 (42S22): Unknown column 'tu' in 'where clause'
ERROR 1054 (42S22): Unknown column 'incrementa' in 'field list'
ERROR 1064 (42000): 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 'END IF' at line 1
ERROR 1064 (42000): 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 'else
SELECT dnr INTO dr FROM devriver_dnr where id = tu' at line 1
ERROR 1193 (HY000): Unknown system variable 'lastdr'
ERROR 1193 (HY000): Unknown system variable 'incrementa'
ERROR 1054 (42S22): Unknown column 'tu' in 'where clause'
ERROR 1054 (42S22): Unknown column 'incrementa' in 'field list'
ERROR 1064 (42000): 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 'END IF' at line 1
ERROR 1193 (HY000): Unknown system variable 'nuevodr'
ERROR 1064 (42000): 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 'END' at line 1
mysql> \t


Desde ya agradezco su ayuda.

[mauritosuarez]

Le estaba faltando los DELIMITER. Habia leido que los DELIMITER solo se utilizaban en la consola.

Saludos.

[gnzsoloyo]

Nop. También si lo cargas por script...