Index: openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	14 May 2009 13:15:57 -0000	1.11
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	10 Oct 2009 22:38:09 -0000	1.12
@@ -201,8 +201,8 @@
 begin
 
 select title into v_choice_value
-from as_item_choicesx
-where choice_id = :new.choice_id;
+from cr_revisions
+where revision_id = :new.choice_id;
 
 update as_item_data set choice_value = coalesce(choice_value,'') || ' ' || coalesce(v_choice_value,'') where item_data_id = :new.item_data_id;
 
