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 concating giving ORA-06502: PL/SQL: numeric or value error: character string buffer too small e

Capil VermaApr 4 2020 — edited Apr 28 2020

***Moderator action (Timo): moved from JDev & ADF to SQL & PL/SQL space***

Hi Team ,

I am having two clob object in plsql . while concatenating both clob object its giving CLOB -ORA-06502: PL/SQL: numeric or value error: character string buffer too small .

my scenario is ;

v_clob clob;

s_clob clob;

select clob_text info s_clob from employee_stock where stock_id=123;

v_clob := v_clob || s_clob ;

so when s_clob have more then 4000 character then its giving ora-6502.

can anyone help me to solve this issue

iit would be really helpful for me if you provide solution .

regards

capil verma

***Moderator action (Timo): removed call out to other users who have not participated in this thread already as this is rude to other users.***

Added on Apr 4 2020

6 comments

1,872 views