DBMS_OUTPUT.PUT_LINE(V_SQL) 报错:ora-06502 缓存区太小

DBMS_OUTPUT.PUT_LINE(V_SQL) 报错:ora-06502 缓存区太小
修改:(分段打印)
for i in 1..5 loop
DBMS_OUTPUT.PUT_LINE(substr(V_SQL,1500*(i-1)+1,1500));
end loop;

 

posted @ 2021-09-02 11:17  梦幻&浮云%  阅读(243)  评论(0编辑  收藏  举报