Hi,
I am using JDeveloper 12.2.1, i have DB adapter as update only, this DB adapter connect to BPEL and expose as REST service, for example i put just 3 field to be updated as below
{
"AgHeader" : {
"agSeq" : 1,
"committeeSeq" : 141,
"note" : "test quick add"
}
}
Now i want to remove data in note field i try to send null and also i try to remove "note" field from JSON requested but nothing happen, data still in table, if i change "DetectOmissions" to be "false" then its work fine but in this case i must send all field in update statment, for example if i call below JSON then "note" field it update to null but also "committeeSeq" update to null
{
"AgHeader" : {
"agSeq" : 1,
"note" : ""
}
}
This is simple example, i have multi REST API with huge schema, so its not good to send all field every time i need to update. (Just i want to update field to be null without DetectOmissions option).
Thanks