Hi team,
I am trying to inserting data in a CLOB type variable which has more than 4000 char,Following are the columns in the table (REGRESSION_TEST_MASTER_TABLE):

TEST_CASE_NO VARCHAR2(50 BYTE)
TSO_LABEL VARCHAR2(255 BYTE)
XML_IN CLOB
OUTPUT_STATUS VARCHAR2(50 BYTE)

I am inserting the data in this table using the query as:

Insert into REGRESSION_TEST_MASTER_TABLE (TEST_CASE_NO, TSO_LABEL, XML_IN, OUTPUT_STATUS) values ('CASE6-CR27979','CHANGETARIFF', 'DATA MORE THAN 4000 CHAR', 'D')

I am getting the error as:
">java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-01704: string literal too long<"


I also tried the query as:

Insert into REGRESSION_TEST_MASTER_TABLE (TEST_CASE_NO,TSO_LABEL,XML_IN,OUTPUT_STATUS) values ('CASE6-CR27979','CHANGETARIFF', 'DATA 4000 char'||'DATA 4000 char'||'DATA 4000 char', 'D')

Still it giving me the error message as:
Error report:
"SQL Error: ORA-01489: result of string concatenation is too long"


Please help me on this. I want to use the same SQL developer and same version to perform this action.
Kindly help.

Thank you.