开发者

File Browse for Uploading Attachments inside and On Demand Process

开发者 https://www.devze.com 2023-03-07 16:43 出处:网络
I am using Oracle ApEx 3.0.1 and I was wondering if the \"File browse\" item type for upload attachments into Oracle ApEx 3.0.1 via an On Demand Process works when calling using ajax call to an on dem

I am using Oracle ApEx 3.0.1 and I was wondering if the "File browse" item type for upload attachments into Oracle ApEx 3.0.1 via an On Demand Process works when calling using ajax call to an on demand process and passing in relevant information.

For the attachment to to added to apex_application_files, does the page need to be submitted as I have my file browse process inside a jQuery dialog box?

Any assistance would be much appreciated.开发者_如何学JAVA

My on demand process code is:

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;

Thanks.


I don't know but there are some potential solutions given here on the Oracle Apex forum.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号