Hi!
I have a situation where I need to return a resultset in json where the data is over 1MB in size. But I struggle with whats looks to be some issue related to either multibyte or some limitation on max "chuck" size on output.
It looks like the response (when containing multibytes) is truncated around character 131095 (approx) and then continued again. But the continuation is not in sync and generates bad json.
Example (fragment from 1mb response file):
148,"CUSTOMER_BUSINESS_UNIT_ID":1,"CUSTOMER_CLIENT_TYPE_ID":1,"CUSTOMER_CLIENT_ID":1012,"REFERENCE_FIELDS":null},{"FIRST_NAME":". Rexho","FULL_NAME":". Rexho","PHONE1":40071981,"GUID":"4BF20E10AD102111E05FIELDS":null},{"FIRST_NAME":". Pal","FULL_NAME":". Pal","PHONE1":90969898,"GUID":"4BF20E10AD082111E0530100007FB484","BUSINESS_UNIT_NAME":"Første forretningsenhet","CUSTOMER_ID":148,"CUSTOMER_BUSINESS_UNIT_ID":1,"CUSTOMER_CLIENT_TYPE_ID":1,"CUSTOMER_CLIENT_ID":1005,"REFERENCE_FIELDS":null},{"FIRST_NAME":". Palm","FULL_NAME":".
I have highlighted around where the json become invalid. This is appox 131098 chars into the response.
Could this be a configuration issue in ORDS, apache or in the database?