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!

Moving CLOB values into a LONG column

2978953Jul 16 2015 — edited Jul 16 2015

Good morning All,

I imported a table from MS Access to Oracle. The table contains a column of the CLOB datatype which I'm trying to convert into LONG so that Informatica can accept it.

I'm not PL/SQL savvy, can anyone please point me to a way to perform this task? IMP/EXP won't work, I tried insert statements into an empty copy of the table but it brings the CLOB column as null.

Your help is greatly appreciated.

Thanks,

Ndiaye

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2015

Added on Jul 16 2015

11 comments

2,825 views