CREATE PROCEDURE Student_InsertTimeLine(
_studentUserCode varchar(300),
_userFrom varchar(300),
_userTo varchar(300),
_operation varchar(300),
_msgTitle varchar(4000),
_activity varchar(4000)
)
BEGIN
SET @strTblQuery = CONCAT("INSERT INTO " , _studentUserCode ,"_Timeline (studentUserCode,userfrom,userto,operation,MessageTitle,activity,dateCreated) VALUES('",_studentUserCode,"','", _userFrom ,"','", _userTo ,"','", _operation ,"','",_msgTitle,"','", _activity ,"','",NOW(),"')");
PREPARE stmt1 FROM @strTblQuery;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END;
CALL Student_InsertTimeLine(
ERROR:
SQL execution error #1065. Response from the database:
Query was empty