Skip to Main Content

APEX

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!

free workspace at apex.oracle.com not available

jmaagApr 7 2021

Did the free workspace from apex.oracle.com stop working?
I click the free workspace link and it says not available. Is the only option to use the autonomous database?

This post has been answered by ranish.p on Apr 7 2021
Jump to Answer

Comments

thatJeffSmith-Oracle

ORDS will always generate lowercase attributes. If you want to enforce case, you'll need to generate the JSON in your handler block and return that, and tell ORDS you're dealing with JSON so it doesn't try to turn your JSON...into JSON.

User_KYPIT

Can you please try to give some example.

Olafur T

Also,
Try creating a single item GET service with

select json_arrayagg(json_object('TYPE' :object_type, 'NAME' :object_name, 'STATUS' :status)) as "{}items"
  from all_objects o
where owner = 'ORDS_METADATA'
fetch next 20 rows only
1 - 4

Post Details

Added on Apr 7 2021
2 comments
248 views