2

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 ?

Paul
  • 714

1 Answers1

3

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

Gary
  • 1,839
  • 10
  • 14