ACS3 Data Model

     1: function im_name_from_user_id(v_user_id IN integer)
     2: return varchar
     3: is
     4:   v_full_name varchar(8000);
     5: BEGIN
     6:   select first_names || ' ' || last_name into v_full_name
     7:    from users
     8:    where user_id = v_user_id;
     9:   return v_full_name;
    10: END im_name_from_user_id;