mysql创建函数报错

添加 DEFINER = CURRENT_USER 和

DETERMINISTIC

CREATE DEFINER = CURRENT_USER FUNCTION `func_getOrgName` (v_org_code varchar(20)) 
RETURNS varchar(200) DETERMINISTIC
BEGIN
declare v_org_name varchar(100);
	select o.ORG_NAME into v_org_name
	from base_org o
	where o.org_code = v_org_code;
	return v_org_name;

END