Index: openacs-4/packages/dotlrn-portlet/sql/oracle/dotlrn-portlet-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-portlet/sql/oracle/dotlrn-portlet-drop.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn-portlet/sql/oracle/dotlrn-portlet-drop.sql	9 Oct 2001 00:04:36 -0000	1.2
+++ openacs-4/packages/dotlrn-portlet/sql/oracle/dotlrn-portlet-drop.sql	17 Nov 2001 22:05:48 -0000	1.3
@@ -34,3 +34,78 @@
 /
 show errors;
 
+declare
+	foo integer;
+begin
+
+	-- add all the hooks
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'MyName'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'GetPrettyName'
+	);
+
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'Link'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'AddSelfToPage'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'Show'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'Edit'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'RemoveSelfFromPage'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'MakeSelfAvailable'
+	);
+
+	foo := acs_sc_impl.delete_alias (
+	       'portal_datasource',
+	       'dotlrn_portlet',
+	       'MakeSelfUnavailable'
+	);
+
+	-- Drop the binding
+	acs_sc_binding.delete (
+	    contract_name => 'portal_datasource',
+	    impl_name => 'dotlrn_portlet'
+	);
+
+	-- drop the impl
+	foo := acs_sc_impl.delete (
+		'portal_datasource',
+		'dotlrn_portlet'
+	);
+end;
+/
+show errors
+
