Skip to Main Content
Forums

SQL & PL/SQL

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!

getting length of CLOB

Vikas KumarJun 3 2009 — edited Jun 3 2009
Hi,

I have a CLOB column in my table which stores XML values. I need to get size of XML stored.
but when i am using length fucntion of oracle,it is giving error character string buffer too small.

can anyone suggest a way out to find the length of CLOB column.

my actual requirement is that i want to create a view in base table with all the field and one more field which will have length of CLOB column value.

Regards,
Vikas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2009
Added on Jun 3 2009
10 comments
599 views