FUNCTION SAMPLE

오라클 펑션 샘플

create or replace FUNCTION UFUN_MAP_RETURN ( I_CD IN VARCHAR2, I_USE_YN IN VARCHAR2 ) RETURN VARCHAR2 IS tmpVar VARCHAR2(4); BEGIN tmpVar := ''; SELECT CD INTO tmpVar FROM TM__MAP WHERE ID = I_CD AND NOW_USE_YN = I_USE_YN; RETURN tmpVar; EXCEPTION WHEN NO_DATA_FOUND THEN RETURN NULL; WHEN OTHERS THEN -- Consider logging the error and then re-raise RAISE; END UFUN_MAP_RETURN;