[altibase]how to make function

• how to make sql function in altibase

CREATE OR REPLACE FUNCTION FUN_GET_CODE_NAME (STR_CODE_TYPE IN VARCHAR(20), STR_CODE IN VARCHAR(20))
RETURN VARCHAR(100)
IS
  RET_CODE VARCHAR(100);
BEGIN
  select CODE_NAME INTO RET_CODE 
  from table_name
    where code_type=str_CODE_TYPE
    AND CODE=str_CODE
    AND USE_YN='Y';
  
    RETURN RET_CODE;
    
    EXCEPTION   
    WHEN NO_DATA_FOUND THEN  
      RETURN '';  
END;

• how to call the function

SELECT FUN_GET_CODE_NAME('A0', 'A2') FROM DUAL;