<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="get_item_title"> <querytext> select title from cr_revisions where item_id = :item_id and revision_id = content_item.get_live_revision(:item_id) </querytext> </fullquery> <fullquery name="unset_live_content_item"> <querytext> begin content_item.unset_live_revision(:item_id); end; </querytext> </fullquery> <fullquery name="audit_update_object"> <querytext> update acs_objects set last_modified = sysdate, modifying_user = :user_id, modifying_ip = :peeraddr where object_id = :item_id </querytext> </fullquery> </queryset>