oracle8.1.6 select forums_messages.*, 0 as n_attachments, person.name(forums_messages.user_id) as user_name, party.email(forums_messages.user_id) as user_email, forums_forum.name(forums_messages.forum_id) as forum_name, forums_message.root_message_id(forums_messages.message_id) as root_message_id, (select fm2.subject from forums_messages fm2 where fm2.message_id = forums_message.root_message_id(forums_messages.message_id)) as root_subject, to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date from forums_messages where forums_messages.message_id = :message_id select forums_messages.*, (select count(*) from attachments where object_id= message_id) as n_attachments, person.name(forums_messages.user_id) as user_name, party.email(forums_messages.user_id) as user_email, forums_forum.name(forums_messages.forum_id) as forum_name, forums_message.root_message_id(forums_messages.message_id) as root_message_id, (select fm2.subject from forums_messages fm2 where fm2.message_id = forums_message.root_message_id(forums_messages.message_id)) as root_subject, to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date from forums_messages where forums_messages.message_id = :message_id select site_node.url(node_id) from site_nodes where object_id = (select package_id from forums_forums where forums_forums.forum_id = :forum_id) declare begin forums_message.delete_thread(:message_id); end; declare begin forums_message.thread_close(:message_id); end; declare begin forums_message.thread_open(:message_id); end;