Index: openacs-4/packages/forums/sql/oracle/forums-reading-info-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-reading-info-package-create.sql,v diff -u -N -r1.1 -r1.1.2.1 --- openacs-4/packages/forums/sql/oracle/forums-reading-info-package-create.sql 15 Jun 2007 10:35:52 -0000 1.1 +++ openacs-4/packages/forums/sql/oracle/forums-reading-info-package-create.sql 23 Apr 2008 16:04:33 -0000 1.1.2.1 @@ -197,7 +197,7 @@ v_target_forum_id forums_forums.forum_id%TYPE; v_users forums_reading_info%ROWTYPE; begin - select forum_id from forums_messages where message_id = p_target_message_id into v_target_forum_id; + select forum_id into v_target_forum_id from forums_messages where message_id = p_target_message_id; for v_users in (select user_id from forums_reading_info fri where root_message_id = p_target_message_id and not exists(select 1 from forums_reading_info where root_message_id = p_source_old_root_message_id and user_id = fri.user_id)) loop delete from forums_reading_info where root_message_id = p_target_message_id and user_id = v_users.user_id;