Hello Gurus,
My requirement is to retrieve through function: if i pass string as parameter, it should return number value. I have tried below one, but it doesn't working.
CREATE OR REPLACE FUNCTION Get_Items_func(ItemName IN varchar(2000))
RETURN NUMBER IS
ItmID number;
BEGIN
SELECT ItemID into ItmID
FROM Items WHERE Item_Name = ItemName;
RETURN (ItmID);
END;
Please help me with this.
Thanks in Advance.