Home/Questions/Q 9618
In Process
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
View Profile
  • 0
Professional
Asked: 2021-11-22T17:01:40+05:30

Showing Error while file upload oracle apex

  • 0

Showing Error while upload file
apex_application_temp_files no data found...!
how can we solve this or any solution.

thanks in advance.

apexoracleupload

    1 Answer

    1. Vinish

      Vinish

      View Profile
      Enlightened

      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.

      • 1

    You must login to add an answer.