This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,805 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

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

bostonmacosx
bostonmacosx Member Posts: 177 Blue Ribbon

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


Tagged:

Answers

  • fac586
    fac586 Senior Technical Architect EdinburghMember Posts: 21,579 Red Diamond
  • bostonmacosx
    bostonmacosx Member Posts: 177 Blue Ribbon

    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
    fac586 Senior Technical Architect EdinburghMember Posts: 21,579 Red Diamond

    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.