Skip to Main Content

ORDS, SODA & JSON in the Database

Handler parameter type BOOLEAN ORDS Oracle Apex not work

Fabio BatistaJun 16 2021
How to get feedback on json as boolean?

Example:
image.pngResult Postman:

<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/M91LQIKAXXOC/image.png" alt="image.png">Unexpected error with the following message: java.lang.Boolean is not supported
Changing the result to text

Example:
image.pngResult Postman:
image.png

As it is a boolean output, the result must be:

{ "result": true }

and not

{ "result": "true" }

Has anyone experienced this problem or is it with this problem and has a solution?
ORDS Version 19.4.0.r3521226
Application Express 19.2.0.00.18

Comments
Post Details
Added on Jun 16 2021
7 comments
271 views