字符串缓冲区太小 [英] character string buffer too small

问题描述

HI ALL

在调试过程时，我得到了

HI ALL

While Debugging the procedure i am getting

"ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512:"

将错误串联到变量中时，在Exception部分中发生了以上错误，但我得到的缓冲区过小错误.

在分配了具有大容量的适当数据类型后，出现了以上错误.

我正在使用VARCHAR2作为该变量的数据类型.

任何人都可以解决我的问题.

Rgds
Jagadesh

The above error is occurring in the Exception part while concatenating the errors into the variable i am getting the buffer too small error.

After assigning a proper datatype with huge size i am getting the above error.

I am using VARCHAR2 as a datatype for that variable.

Can anybody having a solution for my problem.

Rgds
Jagadesh

推荐答案

根据下面的讨论，看起来变量数据类型不足以容纳传递给它的数据.
在PL/SQL中，varchar2可以长达32767；

您需要增加分配更多空间的数据.下面的讨论没有给出建议的答案，建议如何使用它，看看是否有帮助:
ORA -06502字符串缓冲区太小... 1 [ ORA-06502字符串缓冲区太小... 2 [

Based on the discussion below, it looks like the variable datatype is not enough to hold the data being passed to it.
Within PL/SQL a varchar2 can be as long as 32767;

You need to increase the data allocating more space. Discussions below has few answers suggesting ways to do it, see if they help:
ORA-06502 character string buffer too small...1[^]
ORA-06502 character string buffer too small...2[^]

这篇关于字符串缓冲区太小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！