Showing Error while file upload oracle apex

1 Answer

1. 

   

   Vinish

   • 1 Question
   • 847 Answers
   • 74 Best Answers
   • 4k Points

   View Profile

   Vinish Enlightened

   2021-11-22T17:09:08+05:30Added an answer on November 22, 2021 at 5:09 pm

   Try to debug:

   declare
       l_blob blob;
   begin 
     for r in (select * from apex_application_temp_files)
     loop
       apex_debug.message('name: %s - filename: %s', r.name, r.filename);
     end loop;
   
     apex_debug.message('P2_YOURITEM: %s', :P2_YOURITEM);
   
       SELECT blob_content
         INTO l_blob
         FROM apex_application_temp_files
         WHERE name = :P2_YOURITEM;
   
     apex_debug.message('blob length: %s', dbms_lob.getlength(l_blob));
   end;
   

   Run the page and enable debug to see the result.

   • 0

   • Share
     Share

     • Share on Facebook
     • Share on Twitter