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!

Clob To String/Varchar2 Conversion

AdilNov 23 2010 — edited Nov 23 2010
Hi All,
I m converting table data to XML format , which i successfully done and that procedure convert data and save in a CLOB column.
Now i want to convert this clob to Varchar2/String but, I read on fourm that it convert only 4000 chars and when i check my data it is 5036497 character.
This is only a testing data and actual data can be more of that.

Can any one tell me how to do that.


Thanks

Best Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2010
Added on Nov 23 2010
5 comments
899 views