This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
-----------------------------------------------------------------
CREATE FUNCTION FC_GCMRTCD(F_GROUP_CD CHAR(4), F_BASIC_CD CHAR(6))
RETURNS VARCHAR(200)
BEGIN
DECLARE R_REST_CDNM1 VARCHAR(200);
SELECT BASIC_NAME INTO R_REST_CDNM1
FROM G_BASIC
WHERE GROUP_CD = F_GROUP_CD
AND BASIC_CD = F_BASIC_CD;
RETURN R_REST_CDNM1;
END;
** 위와 같이 에러가 나는데..어떤 말인지..ㅠㅠ.. 도와주십쇼 ^^
테이블 생성도 됩니다..ㅠㅠ
|