Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to put a file browser and simple submit button...

bostonmacosxJan 27 2022

I'm unable to get this file into the apex_application_files or wwv_flow_files or anywhere.

Simple submit button and 1 file browser elemetn...

This is step 1...but even after I do this how can I reference the correct file which was just uploaded to do something with it like transcode and sent via a UTL_HTTP call?

thanks
-R
Screen Shot 2022-01-27 at 1.58.04 PM.png

Comments

fac586

Install and review the File Upload & Download sample app.

bostonmacosx

Uses the magic of AutoDML......
They use the AUtoDML and target the uploaded file to a particular table.
I just need it to go to the TEMP FILES....

fac586

I have never had any problems using APEX_APPLICATION_TEMP_FILES.
For example this is a process from a multi-stage data loading wizard:

declare

 l_data_file apex_application_temp_files%rowtype;
  
begin

 select
     aatf.*
 into
     l_data_file
 from
     apex_application_temp_files aatf
 where
     aatf.name = :p11_data_file;
    
 apex_collection.update_member(
      p_collection_name => 'ORR_DATA_FILE'
    , p_seq     => '1'
    , p_n001    => l_data_file.id
    , p_blob001 => l_data_file.blob_content
    , p_c001    => l_data_file.name
    , p_c002    => l_data_file.filename
    , p_c003    => l_data_file.mime_type
    , p_c004    => case l_data_file.mime_type
                     when 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' then 'Excel Workbook'
                     when 'text/csv' then 'CSV'
                     else 'Delimited text'
                   end);
   
end;

P11_DATA_FILE is the File Browse item.

1 - 3

Post Details

Added on Jan 27 2022
#apex-discussions, #file
3 comments
379 views