How to get around ORA-01461 : can bind a LONG value only for insert into a LONG column?
We are trying to do a insert of a big string. Over 4000 chars.
INSERT INTO SYSPDM.PDMIN(RECTYPE,DATA) VALUES ('QA_GEN',REPLACE('Q.(***did not include all data***)_2;;[XXX]','[XXX]',chr(10)))
But we get ORA-01461 : can bind a LONG value only for insert into a LONG column.
How can we insert into a CLOB (col:DATA) a value larger then 4000chars?
Regards
U