Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with file upload with ORDS

WanndererJan 28 2016 — edited Feb 10 2016

Hi,

We have a pure PL/SQL application that is running on ORDS.  We have a problem when trying to upload a file, we are getting an HTTP error 500.

This is our simplified form.

<form method="post" enctype="multipart/form-data">

    <input type="file" value="" name="p_name" id="p_name" data-role="none">

    <input type="submit" name="p_button" value="Submit">

</form>

And this is the error message I can see in my Tomcat logs.

27-Jan-2016 14:52:25.615 SEVERE [ajp-nio-8009-exec-10] oracle.dbtools.http.errors.ErrorPageFilter.log java.sql.SQLException: ORA-20888: p_application_id must be provided

ORA-06512: à "APEX_040200.HTMLDB_UTIL", ligne 2748

ORA-06512: à ligne 1

My apex.docTabl parameter is still at the default value in my defaults.xml.

     https://docs.oracle.com/cd/E56351_01/doc.30/e56293/config_file.htm#AELIG7204

Everyting works fine when I do file upload in Apex, the problem only occurs when trying from ORDS directly.

Thanks a lot

Sebastien

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2016
Added on Jan 28 2016
3 comments
2,756 views