Index: openacs-4/packages/forums/tcl/messages-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/messages-procs-oracle.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/forums/tcl/messages-procs-oracle.xql	15 Jun 2018 16:46:17 -0000	1.9
+++ openacs-4/packages/forums/tcl/messages-procs-oracle.xql	18 Jun 2018 14:22:21 -0000	1.10
@@ -5,27 +5,27 @@
 
     <fullquery name="forum::message::get.select_message">
         <querytext>
-            select forums_messages.*,
+            select m.*,
                    0 as n_attachments,
-                   forums_message.root_message_id(forums_messages.message_id) as root_message_id,
+                   forums_message.root_message_id(m.message_id) as root_message_id,
                    (select subject from forums_messages
-                    where message_id = forums_message.root_message_id(forums_messages.message_id)) as root_subject, 
-                   to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi
-            from forums_messages
-            where forums_messages.message_id = :message_id
+                    where message_id = forums_message.root_message_id(m.message_id)) as root_subject, 
+                   to_char(m.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi
+            from forums_messages m
+            where m.message_id = :message_id
         </querytext>
     </fullquery>
 
     <fullquery name="forum::message::get.select_message_with_attachment">
         <querytext>
-            select forums_messages.*,
-                   (select count(*) from attachments where object_id= message_id) as n_attachments,
-                   forums_message.root_message_id(forums_messages.message_id) as root_message_id,
+            select m.*,
+                   (select count(*) from attachments where object_id = m.message_id) as n_attachments,
+                   forums_message.root_message_id(m.message_id) as root_message_id,
                    (select subject from forums_messages
-                    where message_id = forums_message.root_message_id(forums_messages.message_id)) as root_subject, 
-                   to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi
-            from forums_messages
-            where forums_messages.message_id = :message_id
+                    where message_id = forums_message.root_message_id(m.message_id)) as root_subject, 
+                   to_char(m.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi
+            from forums_messages m
+            where m.message_id = :message_id
         </querytext>
     </fullquery>