Oracle ORDS update columns

386 Views Asked by At

when doing an update through ORDS it updates all the columns. not just the columns provided in the json payload. defaulting columns not provided in json to null.

is there a way to only update columns provided in json data?

1

There are 1 best solutions below

7
On

This is the default behavior when an object is REST enabled through ORDS.ENABLE_OBJECT or by using the Enable Object button if you're in APEX. There is no way to change that behavior. If you want different behavior, you will need to build your own module/template/handler with the logic that you want.