ACS3 Data Model

     1: function im_category_from_id ( v_category_id IN integer )
     2: return varchar
     3: IS
     4:   v_category    categories.category%TYPE;
     5: BEGIN
     6:   select category into v_category from categories where category_id = v_category_id;
     7:   return v_category;
     8: END;