Forum Stats

  • 3,826,361 Users
  • 2,260,636 Discussions
  • 7,896,916 Comments

Discussions

Update field to null in DB adapter

HaniYS
HaniYS Member Posts: 981 Bronze Badge
edited Nov 15, 2021 7:37AM in SOA Suite Discusssions

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

Tagged: