oracle function example

  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;