oracle8.1.6 update download_archive_revisions set approved_p = :approved_p, approved_comment = :approved_comment, approved_user = :user_id, approved_date = sysdate where revision_id = :revision_id begin :1 := acs_mail_nt.post_request( party_from => :user_id, party_to => :creation_user, expand_group => 'f', subject => :subject, message => :body); end;