Index: openacs-4/packages/dotlrn-survey/sql/oracle/dotlrn-survey-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-survey/sql/oracle/dotlrn-survey-create.sql,v
diff -u -N -r1.2 -r1.2.8.1
--- openacs-4/packages/dotlrn-survey/sql/oracle/dotlrn-survey-create.sql	30 Sep 2003 13:11:40 -0000	1.2
+++ openacs-4/packages/dotlrn-survey/sql/oracle/dotlrn-survey-create.sql	27 Dec 2005 00:59:39 -0000	1.2.8.1
@@ -173,7 +173,7 @@
 
        for one_survey in (select s.*, o.creation_user
 		          from surveys s, acs_objects o
-			  where package_id=old_package_id
+			  where s.package_id=old_package_id
 			  and o.object_id=s.survey_id)
        loop
            v_survey_id := survey.new(