建立函数,运行调用,字符数据量大时报-ORA-06502错误我把变量宽试放最大4000也不行。请高手指点迷津!!
CREATE OR REPLACE FUNCTION getscheduleIds(objId in number)
RETURN varchar2 IS
ids varchar2(4000) := '';
v_count integer := 0;
BEGIN
for serId in (select a.assetid from content_iptv_schedule a,Content_Base b where a.channelassetid=objId and b.ACTIVEID=a.id) loop
if v_count > 0 then
ids := ids||','||to_char(serId.assetid);
else
ids := to_char(serId.assetid);
end if;
v_count := v_count+1;
end loop;
RETURN ids;
END getscheduleIds;
报错在:ids := ids||','||to_char(serId.assetid);
请教高手语句有优化余地么?怎么解决报错!!!!急啊!!
报错截图.jpg (20.04 KB, 下载次数: 3)
报错截图
2012-6-19 11:22 上传