Forum Stats

  • 3,768,302 Users
  • 2,252,772 Discussions
  • 7,874,521 Comments

Discussions

ORDS POST. alias column on out resultset param with camelCase

rugal7
rugal7 Member Posts: 2 Red Ribbon

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?

Tagged:
Paul Jorstad

Best Answer

Answers