I am trying to read structures from sdf files with the sdf reader node and write them into a (oracle) database via the Database write node.
This works fine as long as 'append data .. to existing table (if any!)' in the DB writer node is NOT checked: The Molfile (and also ctab) is stored as CLOB in the DB table.
When i use the 'append data...' option' i get the following error for the Molfile column:
Execute failed: Column "molecule" of type "SdfCell" from input does not match type "CLOB" in database at position 0.
Does anyone have an idea why this happens or if i'm doing something wrong?