Handling null in Database
I have an issue in IDOC - DB scenario.
Source field is optional
Target field is mandatory in DB and defined it as Integer in XI [datatype is Numeric in stored procedure]
I mapped the source field in such way that if it is null, then map Constant(Gave null value) else do the necessary transformation and used the mapwithdefault(null) and mapped it to Target field.
This is working fine when there is some value in the source field, but if source field is empty, there is an error.
NumberFormat exception in CommunicationChannel....
Its unable to convert the null to numeric format. But from Database end, I tested through query analyzer by populating some null value into that field and its working fine by accepting the null value.
Any pointers in this..