ACS3 Data Model

     1: function hp_true_neighborhood_name (neighborhood_node IN integer)
     2: return varchar2
     3: IS
     4: 	CURSOR name_cursor IS
     5: 		select neighborhood_name from users_neighborhoods
     6: 		where neighborhood_id=neighborhood_node;
     7: 	CURSOR parent_cursor IS
     8: 		select parent_id from users_neighborhoods
     9: 		where neighborhood_id=neighborhood_node;
    10: 	fullname	varchar(500);
    11: 	parentid	integer;
    12: BEGIN
    13: 	OPEN parent_cursor;
    14: 	OPEN name_cursor;
    15: 	FETCH parent_cursor INTO parentid;
    16: 	FETCH name_cursor INTO fullname;
    17: 	CLOSE parent_cursor;
    18: 	CLOSE name_cursor;
    19: 	IF parentid is null
    20: 	THEN
    21: 		return fullname;
    22: 	ELSE
    23: 		return CONCAT(hp_true_neighborhood_name(parentid), CONCAT(' : ',fullname));
    24: 	END IF;
    25: END;