BEGIN
declare v_dict_cont_name varchar(30);
select dict_cont_name into v_dict_cont_name
from t_sys_dictionary_content con
where con.status = 1 and con.dict_id =( select pid
from t_sys_dictionary dic
where dic.dict_code = p_dict_code and dic.status = 1 )
and dict_cont_code = p_dict_cont_code;
RETURN v_dict_cont_name;
END
declare v_dict_cont_name varchar(30);
select dict_cont_name into v_dict_cont_name
from t_sys_dictionary_content con
where con.status = 1 and con.dict_id =( select pid
from t_sys_dictionary dic
where dic.dict_code = p_dict_code and dic.status = 1 )
and dict_cont_code = p_dict_cont_code;
RETURN v_dict_cont_name;
END