llamar Store procedure

[jucas1987]

Huesos te mando todo el codigo de la base de datos, alfinal esta el procedure.

-- Base de datos: `prueba`

CREATE TABLE IF NOT EXISTS `tblgrado` (
`id_grado` bigint(20) NOT NULL AUTO_INCREMENT,
`grado` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci DEFAULT NULL,
`id_jornada` bigint(20) NOT NULL,
PRIMARY KEY (`id_grado`),
KEY `id_jornada` (`id_jornada`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

INSERT INTO `tblgrado` (`id_grado`, `grado`, `id_jornada`) VALUES
(1, 'Transición', 1),
(2, 'Primero', 1);


DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
SELECT * FROM tblgrado$$