Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	4 Sep 2001 04:50:05 -0000	1.6
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	1 Dec 2001 15:41:50 -0000	1.7
@@ -1377,6 +1377,10 @@
       o.creation_date desc;
 begin
 
+  if item_id is null then
+    return null;
+  end if;
+
   open c_revision_cur;
   fetch c_revision_cur into v_revision_id;
   if c_revision_cur%NOTFOUND then
