I'm creating a workflow for uploading data. In certain cases ti can be that the file to be uploaded (excel) can contain an empty column (no values). If this column is a number column in oracle database the database writer will fail. It has the correct type set under SQL Types tab.
Due to this a tedious workaround is required with the column rename node and String to Number node is neccesary to make it work. You need to create a test file with empty values and only then can you configure the nodes to work in that scenario.
The problem I have with this that a) it works without issue for string columns and b) that these DataValue columns only contain nulls so it should be possible to have the Database writer insert null, regardless of type. Maybe add a check box "Insert DataValue columns as null". This should be easy to implement but a better would be that the Node those this automatically.