SQL & PL/SQL

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.