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

时间:2018-11-03 16:15:44   收藏:0   阅读:1736

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

拼接字符串时过长引起,报缓冲区太小错误

SELECT WM_CONCAT(field_A|| field_b)
FROM table_A
WHERE field_A= ADDRESS.field_A and rownum<10

加上条件限制,让拼接出来的字符串不超长就可以了。

原文:https://www.cnblogs.com/hanhc/p/9900937.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!