Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?

share|improve this question
up vote 3 down vote accepted

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

share|improve this answer
Thank you for your response, I figured out in the end, actually I wanted to convert XML to CLOB and did it with toCLOB() function and it spit this error, but when doing it with getCLOB() it worked. – Paul Dec 8 '09 at 9:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.