oracle8.1.6 declare v_revision_id cr_revisions.revision_id%TYPE; begin content_item.set_live_revision(:revision_id); select id into v_revision_id from cr_wp_slides_preamble where slide_id = :revision_id; content_item.set_live_revision(v_revision_id); select id into v_revision_id from cr_wp_slides_postamble where slide_id = :revision_id; content_item.set_live_revision(v_revision_id); select id into v_revision_id from cr_wp_slides_bullet_items where slide_id = :revision_id; content_item.set_live_revision(v_revision_id); end;