MySQL - hacer dos insert con un procedimiento

create procedure carga

@nom varchar(20),

@esc varchar(20),

@dir varchar(60),

@tel varchar(9)

as

begin

	insert into docente (nom,esc)values(@nom,@esc);

	insert into direc (dir,tel)values(@dir,@tel);

end

USE deb42181_ramos$$

DROP PROCEDURE IF EXISTS sp_insertdocente$$

CREATE PROCEDURE sp_insertdocente(IN getnom varchar(10), IN getesc VARCHAR(50))

BEGIN

insert into docente (nom,esc) values(getnom,getesc);

END$$

# change the delimiter back to semicolon

DELIMITER ;