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!

CLOB more than 4000 characters via DBLink

asim cholasSep 20 2017 — edited Sep 20 2017

Dear Experts,

We have few CLOB columns in a remote database which we are accessing via a DBLink. We have created view in source database with to_char. Now we are using the same field in a procedure to load data to a table. But it is failing due to the size of column more than 4000 with the error

"ORA-64203: Destination buffer too small to hold CLOB data after character set conversion."

Steps we did

created a view in source DB

create or replace view as select to_Char(ClobColumn)ClobtoCharColumn from CLOBTable

2. in the procedure

select ClobtoCharColumn from view@dblink

tried to take substr(ClobtoCharColumn,1,3900) but failed.

any help will be highly appreciated. We need atleast 3900 characters from the column.

Thanks

This post has been answered by AndrewSayer on Sep 20 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2017

Added on Sep 20 2017

4 comments

1,140 views