oracle8.1.6 select g.title as glossary_title, g.revision_id from glossariesx g where g.item_id = :item_id and g.revision_id = content_item.get_latest_revision(:item_id) update acs_objects set last_modified = sysdate, modifying_user = :user_id, modifying_ip = :peeraddr where object_id = :item_id