oracle8.1.6 select acs_message.first_ancestor(:message_id) as ancestor_id from dual