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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Inserting Data to CLOB

805350Nov 15 2010 — edited Nov 16 2010

Hello,

We have a requirement to load the data from one table to another, the source table has the column datatype as "LONG" and the destination table has the datatype "CLOB".

I used the TO_LOB function to load the values from LONG to CLOB but the data does not get copied. Also there is no error showing up. After the insert execution, when i check the data in the destination column, its empty.

Please suggest on what might be going wrong and how do i insert data from the source to destination. The version of oracle that i am using is 8i_

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2010

Added on Nov 15 2010

9 comments

928 views