PLease change given below procedure.


CREATE DEFINER=`root`@`localhost` PROCEDURE `getVendor`(IN `p_VendorUN` VARCHAR(50))
    NO SQL
SELECT v.UserName,v.VendorName, c.CityName,c.CityID, 

a.AreaID,a.AreaName, v.MobileNo, v.EmailID, v.Lane, v.OwnerName, 

v.LandlineNo,v.Status, v.CustomizableFlag
FROM vendor v, city c, area a
WHERE c.CityID = a.CityID
AND a.AreaID = v.AreaID
AND v.UserName = p_VendorUN
AND v.Status = 1