Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
  • 30 Questions
  • 16 Answers
  • 0 Best Answers
  • 185 Points
View Profile
  • 0
Ali AkbarProfessional
Asked: November 22, 20212021-11-22T17:01:40+05:30 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
  • 96
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

    1 Answer

    1. Vinish

      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

    You must login to add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Tutorial

    Recent Blog Posts

    • Vinish

      What is Oracle ERP?

    • Vinish

      The Benefits of Unit Testing

    • Vinish

      Java OOPS Concepts MCQ Quiz

    • Vinish

      What is the Best Database to Use?

    • Vinish

      Sending Query Strings in Post Requests in C#

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • Image to Base64
    • PL/SQL Beautifier

    Creative Commons License
    This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
    © 2021 OrclQA.Com. All Rights Reserved.
    Privacy Policy - About Us