oracle8.1.6 begin :1 := file_storage.new_file( title => :new_file_name, folder_id => :new_folder_id, creation_user => null, creation_ip => null, indb_p => :indb_p ); end; begin :1 := file_storage.new_version( filename => :upload_filename, description => 'Test file', mime_type => :mime_type, item_id => :item_id, creation_user => null, creation_ip => null ); end; update cr_revisions set 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;