oracle8.1.6 declare cursor category_cursor is select distinct category_id from bboard_categories c where c.forum_id = :forum_id; begin for category_val in category_cursor loop delete from acs_permissions where object_id = category_val.category_id; bboard_category.delete(category_val.category_id); end loop; end; begin bboard_forum.delete (:forum_id); end;