Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.