I have created Following Function which takes 2 parameter
CREATE OR REPLACE FUNCTION Inst_Param_Desc(constant_Val IN varchar2(2), display_name1 IN varchar2(40))
RETURN VARCHAR2
IS Front_Display_Name VARCHAR2(40);
Enum_Id number(4,0);
BEGIN
select b.enumeration_id into Enum_Id from xyz b where b.display_name = display_name1;
SELECT a.front_end_display_name
INTO Front_Display_Name
from abc a
where a.enumeration_id = Enum_Id
and a.constant_value = constant_Val;
RETURN Front_Display_Name;
END Inst_Param_Desc;
I am not getting what is wrong with my code