Database writer xml in Oracle problem

KNIME Analytics Platform
1

Hi
when i try to insert with Database Writer node, an XML type record ( more lenght 4000 char), but I receive this error:

ORA-01461: can bind a LONG value only for insert into a LONG column

I try to change type in varchar(25000), CLOB and XMLTYPE but the response is the same.

I’m using jdbc 6, knime 3.4

Is there a different way to do the insert?

thanks

2

Hi there!

Did you check this page? Maybe it will help you.

If I may ask why don’t you upgrade to both newer KNIME and jdbc versions?

Br,
Ivan

3