create or replace function getUser(cn in varchar2) return varchar2
is
Result varchar2(32);
BEGIN
select c.age into Result from color c where c.name = cn;
RETURN Result;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,
'An error was encountered - ' || SQLCODE ||
' -ERROR- ' || SQLERRM);
END getUser;