oracle8.1.6 begin :1 := acs_message.new_image ( message_id => :parent_id, image_id => :attach_id, file_name => :client_filename, title => :title, mime_type => :guessed_file_type, content => empty_blob(), width => :original_width, height => :original_height, creation_user => :user_id, creation_ip => :creation_ip, is_live => :is_live ); end; begin :1 := acs_message.new_file ( message_id => :parent_id, file_id => :attach_id, file_name => :client_filename, title => :title, mime_type => :guessed_file_type, content => empty_blob(), creation_user => :user_id, creation_ip => :creation_ip, is_live => :is_live ); end; select content_item.get_latest_revision(:attach_id) as revision_id from dual update cr_revisions set filename = '$tmp_filename', content_length = $tmp_size where revision_id = :revision_id