topic Re: tDBInput - SELECT CLASS TABLE - ORA-01704: string literal too long in Talend Studio

tDBInput - SELECT CLASS TABLE - ORA-01704: string literal too long

Anonymous — Wed, 23 Jan 2019 17:40:08 GMT

Hi,

In my tDBInput I am quering table for 2 fields like

select id, 'xxxxxxxxxxxxxxxx..........' as data from dummy;

and updating the same table dummy with id as key.

The size of data field is VARCHAR2(8000 BYTE) and has a json document.

The tool has created query_tDBInput as String and since the size of the query is very large than String datatype I am receiving this error.

How could I update a table to assign a field whose size is bigger than String?

Thanks.

Even the query_tDBRow_1 is defined as String. Is there a way to update the table who

akumar2301 — Wed, 23 Jan 2019 18:57:22 GMT

Anonymous — Fri, 25 Jan 2019 16:36:48 GMT

Thanks for the information