CREATE TABLE LOOK_UP_VAL(
LKP_ID NUMBER(10),
LKP_VAL CLOB);
-- below is my update query..
UPDATE LOOK_UP_VAL
SET LKP_VAL = '{"ID":"AREA1","LABEL":"AREA2"..........}'; --my value has more than 4000 characters..
we are getting error : ORA-01704: string literal too long..