Index: openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql,v
diff -u -N -r1.8.2.1 -r1.8.2.2
--- openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql	6 Mar 2006 20:51:07 -0000	1.8.2.1
+++ openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql	2 May 2006 12:53:09 -0000	1.8.2.2
@@ -59,4 +59,16 @@
 	</querytext>
 </fullquery>
 	
+<fullquery name="as::assessment::calculate.sum_of_section_points">
+	<querytext>
+
+	select nvl(sum(m.points), 0) as section_max_points, nvl(sum(d.points), 0) as section_points
+	from as_assessment_section_map m, as_section_data d
+	where m.assessment_id = :assessment_id
+	and m.section_id = d.section_id
+	and d.session_id = :session_id
+
+	</querytext>
+</fullquery>
+
 </queryset>