Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Update field to null in DB adapter

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