Paul Asked: 2009-12-08 07:30:53 +0800 CST2009-12-08 07:30:53 +0800 CST 2009-12-08 07:30:53 +0800 CST Oracle ORA-19011: Character string buffer too small 772 I'm trying to do an insert from a XML column to a CLOB column and I end up with this error. ERROR at line 1: ORA-19011: Character string buffer too small Any ideeas of what i can do ? oracle 1 Answers Voted Best Answer Gary 2009-12-08T13:42:46+08:002009-12-08T13:42:46+08:00 Without seeing the code, it is difficult to be sure. I suspect somewhere you are going via a VARCHAR2 and exceeding either 4000 characters or 32000 characters (depending on whether it is working through SQL or PL/SQL). DB version may help
Without seeing the code, it is difficult to be sure. I suspect somewhere you are going via a VARCHAR2 and exceeding either 4000 characters or 32000 characters (depending on whether it is working through SQL or PL/SQL). DB version may help