Index: openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql	8 Mar 2004 16:50:31 -0000	1.1
+++ openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql	8 Mar 2004 20:12:16 -0000	1.2
@@ -1,11 +1,24 @@
 --
--- lars-blogger-categories-drop.sql
+-- lars-blogger-blogroll-drop.sql
 --
 -- @author Guan Yang (guan@unicast.org)
+-- @author Andrew Grumet (aegrumet@alum.mit.edu)
 --
 
-drop function weblogger_blogroll_entry__delete(integer);
-drop function weblogger_blogroll_entry__new(integer, integer, varchar, varchar, integer, varchar);
-drop function weblogger_blogroll_entry__name(integer);
+begin
+
+  for blogroll_entry in (select link_id from weblogger_blogroll_entries)
+  loop
+    weblogger_blogroll_entry.del(blogroll_entry.link_id);
+  end loop;
+
+  acs_object_type.drop_type('weblogger_blogroll_entry', 't');
+
+end;
+/
+show errors
+
 drop table weblogger_blogroll_entries;
-select acs_object_type__drop_type('weblogger_blogroll_entry', true);
\ No newline at end of file
+drop package body weblogger_blogroll_entry;
+drop package weblogger_blogroll_entry;
+
