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

bostonmacosx

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

fac586

Install and review the File Upload & Download sample app.

bostonmacosx

https://community.oracle.com/tech/developers/discussion/comment/16823542#Comment_16823542

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.