开发者

File Browse for Uploading Attachments inside and On Demand Process

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜