DELIMITER $$ DROP PROCEDURE IF EXISTS `datawarehouse`.`aggregateStudent`$$ CREATE DEFINER=`root`@`%` PROCEDURE `aggregateStudent`(IN adata LONGTEXT) BEGIN DECLARE tempData LONGTEXT; DECLARE fulldata LONGTEXT; DECLARE st1 LONGTEXT; DECLARE sValue LONGTEXT ; DECLARE rFulldata LONGTEXT; DECLARE firstrecord LONGTEXT ; DECLARE len INT ; DECLARE recordsize INT ; DECLARE studentid VARCHAR(50); DECLARE subjectid VARCHAR(50); DECLARE chapterID VARCHAR(50); DECLARE formLevel VARCHAR(50); DECLARE classlevel VARCHAR(50); DECLARE schoolid VARCHAR(50); DECLARE tempSchool VARCHAR(50); DECLARE score DOUBLE(12,2); DECLARE nomore_data INT DEFAULT 0; DECLARE flen INT ; DECLARE ids INT ; DECLARE no_schoolinfo INT DEFAULT 0; SET fulldata=adata; SET firstrecord= SUBSTRING(fulldata,1,INSTR(fulldata,'**')-1); SET rFulldata= SUBSTRING(fulldata,LENGTH(firstrecord)+3,LENGTH(fulldata)); SET tempData=firstrecord; SET recordsize=LENGTH(firstrecord); CREATE TABLE IF NOT EXISTS temp...