I am intending to use the “SDF Reader” node to extract the Mol block and additional data fields from an SDF file and insert it into an Oracle table (Oracle 184.108.40.206.0 / OracleDriver ojdbc8.jar) using the “DB Insert” node. While this works fine for the data fields, I cannot insert the Mol block into a CLOB or VARCHAR2 column. I am running into the following error:
ERROR DB Insert 0:8 Execute failed: Output type mapping is missing for column:
I mapped the Molfile column to CLOB, which did not solve the issue.
Welcome to the forum!
Unfortunately chemistry data types are not supported in the type mapping. However we have a ticket open for this, so it will be possible at some point in the future. Your request is added.
For now, the solution would be to convert the column to string before writing it to the database.
Hope that helps, sorry I don’t have a better answer.