[oracle]FUNCTION

[ORACLE] FUNCTION 예

오라클 FUNCTION 작성 예

CREATE OR REPLACE FUNCTION 
디비명.프로시저명 (
	PARAM_1		IN  VARCHAR2 -- 파라미터1
	,PARAM_2	IN  VARCHAR2 -- 파라미터2
	,PARAM_3	IN  VARCHAR2
) RETURN NUMBER
IS
	returnval               NUMBER := 0; -- 리턴 값

BEGIN

	BEGIN
		SELECT 1 
		INTO returnval
		FROM DUAL;

	 EXCEPTION
		WHEN NO_DATA_FOUND THEN
		returnval := 0;
		WHEN OTHERS THEN
		returnval := 0;
	END;
	RETURN ln_cnt;

	EXCEPTION
	WHEN OTHERS THEN
	RETURN 0;
END;