Oracle Database Discussions

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!

Convert CLOB TO Varchar2

StephenNov 7 2006 — edited Nov 7 2006

Hello All,

I am trying to convert a CLOB value into VARCHAR2 and facing the following issue.

What i did ?

I directly selected the CLOB value and assigned it to a VARCHAR2 variable and it worked fine when trying to run the piece of code in TOAD.

But when i call the same piece of code from a concurrent manager, the varchar2 field comes out with ??????????.

So is there any way to convert a CLOB to VARCHAR2 in Oracle 9i.I tried the TO_CHAR option and that didnt work too...

Thanks,
Arun

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2006

Added on Nov 7 2006

#general-database-discussions

2 comments

752 views