Almacenamiento de procedimientos

[andres18281]

Saludos, no comprendo porque en el workbench aparecen errores.

Aqui les dejo lo que muestra

21:42:14 CREATE PROCEDURE salarios_procedure(OUT nomb varchar, OUT apell VARCHAR,OUT depar VARCHAR) BEGIN SELECT e.Nombre INTO nomb, e.Apellido INTO apell , nomDepartamento INTO depar FROM cargoxempleado ca INNER JOIN empleados e ON ca.codEmpleado = e.codEmpleado INNER JOIN departamentos d ON d.codDepartamento = ca.codDepartamento WHERE salario > 2000000; END Error Code: 1064. 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 ' OUT apell VARCHAR,OUT depar VARCHAR) BEGIN SELECT e.Nombre INTO nomb, e.Apelli' at line 1 0,000 sec

y


21:42:14 DELIMITER; Error Code: 1064. 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 'DELIMITER' at line 1 0,000 sec

Código MySQL:

DELIMITER $$
CREATE PROCEDURE salarios_procedure(OUT nomb varchar, OUT apell VARCHAR,OUT depar VARCHAR)
BEGIN
    SELECT e.Nombre INTO nomb , e.Apellido INTO apell , nomDepartamento INTO depar
    FROM cargoxempleado ca
    INNER JOIN empleados e ON ca.codEmpleado = e.codEmpleado
    INNER JOIN departamentos d ON d.codDepartamento = ca.codDepartamento
    WHERE salario > 2000000;
 end$$
DELIMITER;