Index: openacs-4/packages/assessment/lib/session-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-oracle.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/assessment/lib/session-oracle.xql	8 Apr 2007 17:16:02 -0000	1.1.2.1
+++ openacs-4/packages/assessment/lib/session-oracle.xql	24 Jul 2007 08:23:16 -0000	1.1.2.2
@@ -23,8 +23,8 @@
         and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
 	and o.object_id = cr.item_id
         and s.session_id = cr.revision_id
+	and rownum=1
 	group by assessment_id, subject_id, session_id
-	limit 1
     </querytext>
 </fullquery>