Index: openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql 16 Jan 2003 13:59:05 -0000 1.2 +++ openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql 30 Sep 2003 12:10:11 -0000 1.3 @@ -76,7 +76,7 @@ return v_item_id; end; - procedure delete ( + procedure del ( static_page_id in static_pages.static_page_id%TYPE ) is begin @@ -97,14 +97,14 @@ where parent_id = comment_row.comment_id ); - acs_message.delete(comment_row.comment_id); + acs_message.del(comment_row.comment_id); end loop; -- Delete the page. -- WE SHOULDN'T NEED TO DO THIS: CONTENT_ITEM.DELETE SHOULD TAKE CARE OF -- DELETING FROM STATIC PAGES. - delete from static_pages where static_page_id = static_page.delete.static_page_id; - content_item.delete(static_page_id); + delete from static_pages where static_page_id = static_page.del.static_page_id; + content_item.del(static_page_id); end; function get_root_folder ( @@ -252,11 +252,11 @@ select static_page_id from static_pages where folder_id = folder_row.folder_id ) loop - static_page.delete(page_row.static_page_id); + static_page.del(page_row.static_page_id); end loop; delete from sp_folders where folder_id = folder_row.folder_id; - content_folder.delete(folder_row.folder_id); + content_folder.del(folder_row.folder_id); end loop; end; @@ -283,7 +283,7 @@ where session_id = static_page.delete_stale_items.session_id ) ) loop - static_page.delete(stale_file_row.static_page_id); + static_page.del(stale_file_row.static_page_id); end loop; -- Now delete all folders that aren't in sp_extant_folders. There are two @@ -314,7 +314,7 @@ delete from sp_folders where folder_id = stale_folder_row.folder_id; - content_folder.delete(stale_folder_row.folder_id); + content_folder.del(stale_folder_row.folder_id); end loop; end delete_stale_items;