Skip to Main Content
Forums

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MAKE_REST_REQUEST : ORA-29270

Jon BarwellMar 20 2017 — edited Mar 20 2017

I have been developing calls to an external RESTFUL webservice and have successfully got GET and PUT requests working using APEX_WEB_SERVICE.MAKE_REST_REQUEST.

I am using Oracle db 12.1.02 and Apex 5.0.0.

However, when I have called a service that is a POST request, I have received HTTP timeout errors and then finally a "ora-29270: too many open http requests".  Part of the problem I am having is once I start getting these errors is that the GETs and PUTs stop working.

I have potentially got another solution which I have developed using UTL_HTTP but that will also need some changes at the DB level to open up ACLs.

Investigations have led me to believe that his might be something that can be fixed by patching to 5.0.1 but I can't find any definitive answer, or do I just get the ACLs opened?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 17 2017
Added on Mar 20 2017
#apex-discussions
7 comments
2,072 views