311: procedure clean_pois
312: is
313: cursor c1( start_id NUMBER ) is
314: select poi_id, rowid 315: from csf_md_pois 316: where poi_id >= start_id
317: order by poi_id;
318: r1 c1%ROWTYPE;
319:
Line 339: delete from csf_md_pois where rowid = r1.rowid;
335: exit;
336: end if;
337:
338: if ( min_start_id = r1.poi_id ) then 339: delete from csf_md_pois where rowid = r1.rowid; 340: else
341: min_start_id := r1.poi_id;
342: end if;
343: