Discussion:
Error SQL0433N - Value is too long UDF issue
(too old to reply)
Justin
2007-03-14 15:09:22 UTC
Permalink
I have a function that has a varchar about 300 characters. When I run
the insert command from a function I receive the error SQL0433N -
Value .... is too long SQLSTATE=22001.

If I run the query outside of the function it seems to work fine. I
read about char limitations of 255 characters does a user defined
function (UDF) limit me with 255 characters as well?
Justin
2007-03-14 19:23:07 UTC
Permalink
The string was casted with char(). Therefore it was limited to 256
characters. Issue solved.
Post by Justin
I have a function that has a varchar about 300 characters. When I run
the insert command from a function I receive the error SQL0433N -
Value .... is too long SQLSTATE=22001.
If I run the query outside of the function it seems to work fine. I
read about char limitations of 255 characters does a user defined
function (UDF) limit me with 255 characters as well?
Loading...