How to use converttoclob function
174951Apr 20 2005 — edited Apr 22 2005I 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