oracle8.1.6 select bookmark_id from (select bookmark_id, url_id from bm_bookmarks start with parent_id = :root_folder_id connect by prior bookmark_id = parent_id) bm where acs_permission.permission_p(bm.bookmark_id, :browsing_user_id, 'delete') = 't' and bm.url_id = :url_id begin bookmark.del ( bookmark_id => :bookmark_id ); end; begin bookmark.del ( bookmark_id => :bookmark_id ); end;