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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Custom HTTP status implementing AutoRest enabled object

LeandroideOct 11 2019

Hi Guys, here Leandro from Argentina.

I have enabled a lot of objects from our DB, like procedures and functions. This is an awesome feature, that saved us effort, time, resources, and money, so this is the way we are working, enabling DB objects.

The fact is that I am looking for a way to indicate from my stored enabled proc, to ORDS that I am changing the response status.

Is there any hack/way/manner to achieve this? How do ORDS maps :status OUTparam, to X-ORDS-STATUS-CODE internally, when using module creation mode?

If there is not, how do you deal with unsuccessful enabled procedures, functions? I would like to return something like:

Status 500 Internal Server Error

Body { message: "The operation can not be performed. Try again later. Sorry" }

Thanks in advance, and the OOW2019 was great.

Comments

843851
If not Thread.sleep() then what? Why is this not satisfying you?
843851
oh, I am mistaken. Thanks
1 - 2

Post Details

Added on Oct 11 2019
0 comments
90 views