Apex 5.0 Not Allowing Large SQL Queries in RESTFul - Get Services
(Doc ID 2073733.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Application Express (APEX) - Version 5.0.1.00 to 5.0.4 [Release 5]
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 17-Feb-2019 ****
On : APEX 5.0 version, SQL Workshop
When attempting to enter a large query while 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.
Upgrade to APEX 5.0
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document