oracle8.1.6 select nvl(content_item.get_path(:parent_id), '/') as item_path, pretty_name as content_type_name from acs_object_types where object_type = :content_type