Skip to Main Content

ORDS, SODA & JSON in the Database

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!

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

thatJeffSmith-Oracle

you found a bug, not related to APEX, just straight up ORDS

I'll log the issue for you

Fabio Batista
<a href="https://community.oracle.com/tech/developers/discussion/comment/16799206#Comment_16799206" alt="undefined type="undefined">undefined</a> (0 Bytes)Thanks.
I found the similar question right here and without resolution, but very old from April 2016

Handler parameter type BOOLEAN not supported (0 Bytes)
The same problem occurs on an updated basis with versions:
ORDS Version 21.1.1.r1162032
Application Express 21.1.0

partlycloudy

@thatjeffsmith-oracle Has this bug been resolved yet? Any ETA?

gimme the code vs a screenshot and i'll try it right quick

partlycloudy

I just tried it in ORDS 20.4 and I see the OP said they tried in ORDS 21.1.1.r1162032 and the issue is still there
Basically, does ORDS.DEFINE_PARAMETER p_param_type support BOOLEAN as documented? If it does, can we see an example that works?

I logged this issue in mid-June. It has not been addressed in an ORDS release, yet.

User_2JVWU

Still present in 22.1.1 :(

1 - 7

Post Details

Added on Jun 16 2021
7 comments
544 views