定义公共的Function－－根据cd得到value篇

create or replace FUNCTION          USF_GET_SYS_SET_VALUE
/*
    Copyright(c) 1987-2003 eBworx,Inc.
    Remark : First Creation (hwchang 20041113)
*/

(cd_in IN tbl_sys_set.cd%TYPE)

RETURN tbl_sys_set.value%TYPE

AS
    v_value tbl_sys_set.value%TYPE;

BEGIN
    BEGIN
        SELECT    tbl_sys_set.value INTO v_value
            FROM  tbl_sys_set
            WHERE tbl_sys_set.cd = cd_in;

        EXCEPTION
            WHEN NO_DATA_FOUND THEN
                v_value := '';

    END;

    RETURN v_value;

END USF_GET_SYS_SET_VALUE;