아래 프로시저에서 어느부분이 잘못되었는지 생성이 안되네요.
CREATE PROCEDURE SP_GET(PART_ID VARCHAR(4), USER_ID VARCHAR(4))
RETURNING INT AS AVG_TOT;
DEFINE CNT INT;
DEFINE TOT INT;
DEFINE AVG_TEMP INT;
SELECT COUNT(*) INTO CNT
FROM TB_A
WHERE DEPT_CD = DEPT_CD
AND USER_ID = USER_ID;
SELECT COUNT(*) INTO TOT
FROM TB_B
WHERE DEPT_CD = DEPT_CD
AND USER_ID = USER_ID;
IF ( TOT != NULL && TOT != 0 )
SET AVG_TEMP = TOT / CNT;
ELSE
SET AVG_TEMP = 0;
RETURN AVG_TEMP;
END PROCEDURE; |