Database adapter update to null doesn't work
Hi,
I have a BPEL-proces what has to do an update on a database table. When the value of one of the columns is changing to null, the update doesn't work. The value in the database column does not change to null, the old value is still there. Other values where the new value is not null do change. In the BPEL-console I can see that the column is empty in the xml right before the update. The column in the database is not mandatory. I also used a merge but this also doesn't work.
When I do an update from sqldeveloper it works. When I add an Assign-activity in bpel with a copy of '' to the field the field is updated to null. What is the difference between an Assign and Transform? Oracle advices to use a transform when you have more than four copy-operations in an assign.
what can I do to get the update right?
Do you have some idea's?
I'm using Oracle Application Server and Oracle Soa Suite 10.1.3.5
Herman
Edited by: user1950921 on 27-Apr-2011 05:11