Appian 7.9 Cloud: I tried to create a stored procedure with the following sql:

Appian 7.9 Cloud: I tried to create a stored procedure with the following sql:
CREATE DEFINER=`appian`@`%` PROCEDURE `ABC`(IN `name` VARCHAR(50), IN `address` TINYINT(1))
BEGIN
INSERT INTO `Appian`.`PQR` (Name,Address) VALUES (name,address);
END
It gave me an error:
#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 '' at line 3
Here line 3 is the INSERT statement. I then successfully created it automatically from the workbench without using manual scripts and downloaded the script:

CREATE DEFINER=`appian`@`%` PROCEDURE `ABC`(IN `name` VARCHAR(50), IN `address` TINYINT(1))
NO SQL
INSERT INTO `Appian`.`PQR` (Name,Address) VALUES (name,address);
The only difference between what I was trying to create and what Appian created is that BEGIN and END have been replaced by NO SQL. Can any one explain the behaviour?

OriginalPostID-160455

OriginalPostID-160455