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!

Using ORDS to generate the JSON. The file is generated with tags in lowercase instead of upperc

User_KYPITAug 19 2022

Using ORDS to generate the JSON. The file is generated with tags in lowercase instead of uppercase or initcap as provided in SQL query

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 Aug 19 2022
4 comments
401 views