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 convert varchar2 vairable to CLOB variable

529476Sep 14 2006 — edited Sep 15 2006

Hi,

I want to convert my varchar2 vairable to CLOB to store data is there any way to do so ?

I have seen one pkg DBMS_LOB but I unable to understand & how to use that.
The DBMS_LOB package converts BFILE data to CLOB, not varchar to clob.
so If any one knows how I can write into BFILE and then I can convert it to CLOB.

Regards,
Sandeep Sharma

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2006

Added on Sep 14 2006

3 comments

776 views