oracle8.1.6 select to_char(to_date(:value, :date_format), 'YYYY-MM-DD') from dual select $attribute as value, r.title as page_title from cr_revisions r, cr_items i where i.parent_id = etp.get_folder_id(:package_id) and i.name = :name and i.item_id = r.item_id and r.revision_id = :old_revision_id select etp.get_attribute_value(r.revision_id, :attribute_id) as value, r.title as page_title from cr_items i, cr_revisions r where i.parent_id = etp.get_folder_id(:package_id) and i.name = :name and i.item_id = r.item_id and r.revision_id = :old_revision_id begin :1 := etp.create_new_revision( :package_id, :name, :user_id, :revision_id ); end;