为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:windows
【CPU】:
【问题描述】*:
这是我的返回值, 调试返回的数据,
$,3750,3751,3760,3761,3764,3770,3778,3786,3793,3798,3806,3817,3825,3835,3844,3853,3854,3858,3752,3753,3754,3755,3756,3757,3758,3759,3762,3763,3765,3766,3767,3768,3769,3771,3772,3773,3774,3775,3776,3777,3779,3780,3781,3782,3783,3784,3785,3787,3788,3789,3790,3791,3792,3794,3795,3796,3797,3799,3800,3801,3802,3803,3804,3805,3807,3808,3809,3810,3811,3812,3813,3814,3815,3816,3818,3819,3820,3821,3822,3823,3824,3826,3827,3828,3829,3830,3831,3832,3833,3834,3836,3837,3838,3839,3840,3841,3842,3843,3845,3846,3847,3848,3849,3850,3851,3852,3855,3856,3857,3859,3860,3861,3862,3863,3864
这个是我创建的函数, 我吧返回值varchar改成了2W还是报字符串截断的错误
CREATE OR REPLACE FUNCTION “SYSDBA”.“QUERYCHILDRENAREAINFO”(“areaId” IN VARCHAR(64))
RETURN VARCHAR(20000)
AS
DECLARE
sTempChd VARCHAR(10000);
sTemp VARCHAR(20000);
BEGIN
sTemp = ‘$’;
sTempChd = CAST(areaId AS VARCHAR(10000));
WHILE sTempChd IS NOT NULL LOOP
sTemp = CONCAT(sTemp, ',', sTempChd);
print length(sTemp);
SELECT WM_CONCAT(oid) INTO sTempChd
FROM org_organization
WHERE sys_isdeleted = '0'AND FIND_IN_SET(parent_Id, sTempChd) >0;
END LOOP;
RETURN sTemp;
END;
这个返回值才576个字符,
跟定义的varchar4000个字符没关系吧?
是不是根据你们返回的数据分页或者大小指定有关系呢???