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

[Anonymous]

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 · Accepted solution]

this is oracle error when varchar size is more then 4000 or a Clob.

quick google search gave me below links. hope these could help you to resolve this issue
https://stackoverflow.com/questions/13945710/error-ora-01704-string-literal-too-long


https://community.talend.com/t5/Design-and-Development/How-to-get-the-values-dynamically-in-tOracleI...

https://community.talend.com/t5/Design-and-Development/How-to-get-the-values-dynamically-in-tOracleI...

[Anonymous]

Thanks for the information