Skip to Main Content
Forums

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!

ORDS POST. alias column on out resultset param with camelCase

rugal7Jan 29 2021 — edited Jan 29 2021

Hi.
I just need to retrieve in json body response data from a ref cursor with the name of tags camel case. For example:
Cursor:
Select 1 as "numClient", 'test' as "clientName" from dual;
I need:
{"numClient" : 1, "clientName": "test" }
But the alias in ords have been set in lowercase:
{"numclient" : 1, "clientname": "test" }
Is it posible to use camelCase alias columns for a param out resultset?
This post has been answered by thatJeffSmith-Oracle on Feb 1 2021
Jump to Answer

Comments

Zoltan Kecskemethy

Have you measured network connection speed between two systems?

Mannamal-Oracle

Copy to Hadoop, a feature licensed with Oracle Big Data SQL, is a better alternative to Sqoop.  Faster and supported by Oracle.

1 - 2

Post Details

Added on Jan 29 2021
3 comments
575 views