oracle8.1.6 select :path || filename from cr_revisions where revision_id = :revision_id select content from cr_revisions where revision_id = :revision_id begin :1 := image.new( name => :object_name, parent_id => :parent_id, item_id => :item_id, revision_id => :revision_id, mime_type => :mime_type, creation_user => :creation_user, creation_ip => :creation_ip, title => :title, content_type => :image_type, storage_type => :storage_type, height => :original_height, width => :original_width, package_id => :package_id ); end; begin :1 := image.new_revision ( item_id => :item_id, revision_id => :revision_id, title => :title, description => :description, mime_type => :mime_type, creation_user => :creation_user, creation_ip => :creation_ip, height => :original_height, width => :original_width, package_id => :package_id ); end; begin :1 := content_item.new( name => :object_name, item_id => :item_id, parent_id => :parent_id, context_id => :parent_id, creation_user => :creation_user, creation_ip => :creation_ip, content_type => :other_type, storage_type => :storage_type, package_id => :package_id ); end; begin :1 := content_revision.new ( title => :title, description => :description, mime_type => :mime_type, item_id => :item_id, revision_id => :revision_id, creation_user => :creation_user, creation_ip => :creation_ip, package_id => :package_id, filename => :object_name ); end; update cr_revisions set mime_type = :mime_type, content = empty_blob() where revision_id = :revision_id returning content into :1 update cr_revisions set content_length = dbms_lob.getlength(content) where revision_id = :revision_id begin content_item.set_live_revision (revision_id => :revision_id); end;