问文件浏览，用于在内部和按需流程中上传附件

EN

BEGIN
  IF ( :AI_FILENAME is not null ) then 
      insert into request_attachments 
                          ( request_id,
                            doc_reference,
                            name,
                            description,
                            contents, 
                            mime_type ) 
      select 100,
             :AI_DOC_REFERENCE,
             substr(:AI_FILENAME, instr(:AI_FILENAME, '/')+1),
             :AI_DESCRIPTION,
             blob_content,
             mime_type
      from   apex_application_files where name = :AI_FILENAME;

      delete from wwv_flow_files where name = :AI_FILENAME;
  END IF;
END;