Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-19011 Character stringbuffer too small

450482Apr 17 2008 — edited Apr 23 2008
Hi
How can I re-write the following query in such a way that i can get rid of the error I am getting?

select distinct t1.xmlcol.extract('//c/RHS/value/text()').getStringVal()
from table1 t1

Here is the error:
ora-19011 Character stringbuffer too small
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2008
Added on Apr 17 2008
#performance-availability, #xml-db
11 comments
5,390 views