Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/jobs-kill.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/Attic/jobs-kill.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/jobs-kill.sql	5 Apr 2001 18:23:38 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/jobs-kill.sql	26 Aug 2001 13:39:26 -0000	1.2
@@ -22,6 +22,8 @@
 	    job => job_no
 	);
     end if;
+    close timed_trans_cur;
+    close hold_timeout_cur;
 
 end;
 /
Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/jobs-start.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/Attic/jobs-start.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/jobs-start.sql	5 Apr 2001 18:23:38 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/jobs-start.sql	26 Aug 2001 13:39:26 -0000	1.2
@@ -40,6 +40,8 @@
 	    interval => 'sysdate + 1/24/4'
 	);
     end if;
+    close timed_trans_cur;
+    close hold_timeout_cur;
 
 end;
 /
Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql	24 Aug 2001 19:56:31 -0000	1.3
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql	26 Aug 2001 13:39:26 -0000	1.4
@@ -843,6 +843,7 @@
             v_notification_callback := null;
             v_notification_custom_arg := null;
         end if;
+        close c_callback;
 
         -- notify any new assignees
 
@@ -1088,6 +1089,7 @@
                 v_deadline := null;
             end if;
         end if;
+        close case_deadline_cur;
         
         return v_deadline;
     end get_task_deadline;
Index: openacs-4/packages/cms/sql/oracle/cms-permissions.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/oracle/cms-permissions.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/sql/oracle/cms-permissions.sql	20 Apr 2001 20:51:09 -0000	1.1
+++ openacs-4/packages/cms/sql/oracle/cms-permissions.sql	26 Aug 2001 13:39:26 -0000	1.2
@@ -323,6 +323,7 @@
     if c_perm_cur%NOTFOUND then
       v_ret := 'f';
     end if;
+    close c_perm_cur;
     return v_ret;
   end has_revoke_authority;