I am trying to execute SHOP_MATERIAL_ALLOC_API.MODIFY__ and am getting this error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "IFSAPP.CLIENT_SYS", line 111
ORA-06512: at "IFSAPP.SHOP_MATERIAL_ALLOC_API", line 2979
ORA-06512: at line 1
I have no idea what it means. Can someone help me understand this error?
Hello
It solely means that the parameter you’ve defined isn’t large enough to hold the data you pass \ assign to it. That’s nothing related to IFS but purely Oracle, specifically its PLSQL engine.
Only available options is to increase the size of the VARCHAR2.
If that isn’t feasible (as the data are much larger than 32000 chars, you can try using a CLOB instead.
Hope this helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.