Apex 5.0 Not Allowing Large SQL Queries Creating New RESTFul - Get Services
Last updated on JULY 07, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 5.0.1.00 to 5.0.4 [Release 5]
Information in this document applies to any platform.
On : 5.0.1.00 version, SQL Workshop
When attempting to enter a large query when creating a GET method Restful Services Query, the query is limited to only 4000 characters.
Be able to enter the long queries (5000 characters or more) as it was accepted in previous version (4.2).
1. Go to Home -> SQL Workshop -> RESTful Services -> Create RESTful Service Module -> For Method select Get -> See Query Field.
2. Copy and paste a query with more than 4000 characters into the query field.
3. The query is entered incomplete and you cannot enter more characters.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms