Skip to Main Content

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!

How to use converttoclob function

174951Apr 20 2005 — edited Apr 22 2005
I am using 9.2.0.1

I have mistakenly created a blob column instead of
clob column. My purpose of this CLOB column is RTF file.

I tried to use UTL_RAW.CAST_TO_VARCHAR2(b.note_text)
to convert the blob to clob. The content of
BLOB is an RTF file.
When I used the above and tried to open through my app
I was not able to open the RTF file.

Can any one give me ann examples on how to use DBMS_LOB.CONVERTTOLOB. Thanks.

Divya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2005
Added on Apr 20 2005
8 comments
14,250 views